{"id":12634,"date":"2019-07-17T07:50:41","date_gmt":"2019-07-17T05:50:41","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/schedule-reboots-of-your-aws-instances-and-how-that-can-result-in-a-hard-reboot-and-corruption\/"},"modified":"2019-07-17T07:50:41","modified_gmt":"2019-07-17T05:50:41","slug":"schedule-reboots-of-your-aws-instances-and-how-that-can-result-in-a-hard-reboot-and-corruption","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/schedule-reboots-of-your-aws-instances-and-how-that-can-result-in-a-hard-reboot-and-corruption\/","title":{"rendered":"Schedule reboots of your AWS instances and how that can result in a hard reboot and corruption"},"content":{"rendered":"

From time to time you might require to reboot your AWS instances. Maye you applied some patches or for whatever reason. Rebooting an AWS instance can be done in several ways: You can of course do that directly from the AWS console<\/a>. You can use the AWS command line utilities<\/a> as well. If you want to schedule a reboot you can either do that using CloudWatch<\/a> or you can use SSM Maintenance Windows<\/a> for that. In this post we will only look at CloudWatch and System Manager as these two can be used to schedule the reboot easily using AWS native utilities. You could, of course, do that as well by using cron and the AWS command line utilities but this is not the scope of this post. <\/p>\n

<\/p>\n

For CloudWatch the procedure for rebooting instances is the following: Create a new rule:<\/p>\n

\"\"<\/a><\/p>\n

Go for “Schedule” and give a cron expression. In this case it means: 16-July-2019 at 07:45. Select the “EC2 RebootInstances API call” and provide the instance IDs you want to have rebooted. There is one limitation: You can only add up to five targets. If you need more then you have to use System Manager as described later in this post. You should pre-create an IAM role<\/a> with sufficient permissions which you can use for this as otherwise a new one will be created each time.<\/p>\n

\"\"<\/a><\/p>\n

Finally give a name and a description, that’s it:<\/p>\n

\"\"<\/a>
\n\"\"<\/a><\/p>\n

Once time reaches your cron expression target the instance(s) will reboot.<\/p>\n

The other solution for scheduling stuff against many instances is to use AWS SSM. It requires a bit more preparation work but in the end this is the solution we decided to go for as more instances can be scheduled with one maintenance window (up to 50) and you could combine several tasks, e.g. executing something before doing the reboot and do something else after the reboot.<\/p>\n

The first step is to create a new maintenance window:
\n\"\"<\/a><\/p>\n

Of course it needs a name and an optional description:
\n\"\"<\/a><\/p>\n

Again, in this example, we use a cron expression for the scheduling (some as above in the CloudWatch example). Be aware that this is UTC time:
\n\"\"<\/a><\/p>\n

Once the maintenance window is created we need to attach a task to it. Until now we only specified a time to run something but we did not specify what to run. Attaching a task can be done in the task section of the maintenance window:
\n\"\"<\/a><\/p>\n

In this case we go for an “Automation task”. Name and description are not required:
\n\"\"<\/a><\/p>\n

The important part is the document<\/a> to run, in our case it is “AWS-RestartEC2Instance”:
\n\"\"<\/a><\/p>\n

Choose the instances you want to run the document against:
\n\"\"<\/a><\/p>\n

And finally specify the concurrency and error count and again, an IAM role with sufficient permissions to perform the actions defined in the document:
\n\"\"<\/a><\/p>\n

Last, but not least, specify a pseudo parameter called “{TARGET_ID}” which will tell AWS SSM to run that against all the instances you selected in the upper part of the screen:
\n\"\"<\/a><\/p>\n

That’s it. Your instances will be rebooted at the time you specified in the cron expression. All fine and easy and you never have to worry about scheduled instance reboots. Just adjust the cron expression and maybe the list of instances and you are done for the next scheduled reboot. Really? We did it like that against 100 instances and we got a real surprise. What happened? Not many, but a few instances have been rebooted hard and one of them even needed to be restored afterwards. Why that? This never happened in the tests we did before. When an instance does not reboot within 4 minutes AWS performs a hard reboot<\/a>. This can lead to corruption as stated here<\/a>. When you have busy instances at the time of the reboot this is not what you want. On Windows you get something like this:
\n\"\"<\/a>
\n\"\"<\/a><\/p>\n

You can easily reproduce that by putting a Windows system under heavy load with a cpu stress test<\/a> and then schedule a reboot as described above. <\/p>\n

In the background the automation document calls aws:changeInstanceState<\/a> and that comes with a force parameter:
\n\"\"<\/a><\/p>\n

… and here we have it again: Risk of corruption. When you take a closer look at the automation document that stops an EC2 instance you can see that as well:
\n\"\"<\/a><\/p>\n

So what is the conclusion of all this? It is not to blame AWS for anything, all is documented and works as documented. Testing in a test environment does not necessarily mean it works on production as well. Even if it is documented you might not expect it because your tests went fine and you missed that part of the documentation where the behavior is explained. AWS System Manager still is a great tool for automating tasks but you really need to understand what happens before implementing it in production. And finally: Working on public clouds make many things easier but others harder to understand and troubleshoot.<\/p>\n","protected":false},"excerpt":{"rendered":"

From time to time you might require to reboot your AWS instances. Maye you applied some patches or for whatever reason. Rebooting an AWS instance can be done in several ways: You can of course do that directly from the AWS console. You can use the AWS command line utilities as well. If you want […]<\/p>\n","protected":false},"author":29,"featured_media":12635,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229],"tags":[133],"type_dbi":[],"class_list":["post-12634","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-administration-monitoring","tag-aws"],"acf":[],"yoast_head":"\nSchedule reboots of your AWS instances and how that can result in a hard reboot and corruption - dbi Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/schedule-reboots-of-your-aws-instances-and-how-that-can-result-in-a-hard-reboot-and-corruption\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Schedule reboots of your AWS instances and how that can result in a hard reboot and corruption\" \/>\n<meta property=\"og:description\" content=\"From time to time you might require to reboot your AWS instances. Maye you applied some patches or for whatever reason. Rebooting an AWS instance can be done in several ways: You can of course do that directly from the AWS console. You can use the AWS command line utilities as well. If you want […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/schedule-reboots-of-your-aws-instances-and-how-that-can-result-in-a-hard-reboot-and-corruption\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2019-07-17T05:50:41+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Selection_074.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"663\" \/>\n\t<meta property=\"og:image:height\" content=\"455\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Daniel Westermann\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@westermanndanie\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Daniel Westermann\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/schedule-reboots-of-your-aws-instances-and-how-that-can-result-in-a-hard-reboot-and-corruption\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/schedule-reboots-of-your-aws-instances-and-how-that-can-result-in-a-hard-reboot-and-corruption\/\"},\"author\":{\"name\":\"Daniel Westermann\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66\"},\"headline\":\"Schedule reboots of your AWS instances and how that can result in a hard reboot and corruption\",\"datePublished\":\"2019-07-17T05:50:41+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/schedule-reboots-of-your-aws-instances-and-how-that-can-result-in-a-hard-reboot-and-corruption\/\"},\"wordCount\":843,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/schedule-reboots-of-your-aws-instances-and-how-that-can-result-in-a-hard-reboot-and-corruption\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Selection_074.jpg\",\"keywords\":[\"AWS\"],\"articleSection\":[\"Database Administration & Monitoring\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/schedule-reboots-of-your-aws-instances-and-how-that-can-result-in-a-hard-reboot-and-corruption\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/schedule-reboots-of-your-aws-instances-and-how-that-can-result-in-a-hard-reboot-and-corruption\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/schedule-reboots-of-your-aws-instances-and-how-that-can-result-in-a-hard-reboot-and-corruption\/\",\"name\":\"Schedule reboots of your AWS instances and how that can result in a hard reboot and corruption - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/schedule-reboots-of-your-aws-instances-and-how-that-can-result-in-a-hard-reboot-and-corruption\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/schedule-reboots-of-your-aws-instances-and-how-that-can-result-in-a-hard-reboot-and-corruption\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Selection_074.jpg\",\"datePublished\":\"2019-07-17T05:50:41+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/schedule-reboots-of-your-aws-instances-and-how-that-can-result-in-a-hard-reboot-and-corruption\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/schedule-reboots-of-your-aws-instances-and-how-that-can-result-in-a-hard-reboot-and-corruption\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/schedule-reboots-of-your-aws-instances-and-how-that-can-result-in-a-hard-reboot-and-corruption\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Selection_074.jpg\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Selection_074.jpg\",\"width\":663,\"height\":455},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/schedule-reboots-of-your-aws-instances-and-how-that-can-result-in-a-hard-reboot-and-corruption\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Schedule reboots of your AWS instances and how that can result in a hard reboot and corruption\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66\",\"name\":\"Daniel Westermann\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g\",\"caption\":\"Daniel Westermann\"},\"description\":\"Daniel Westermann is Principal Consultant and Technology Leader Open Infrastructure at dbi services. He has more than 15 years of experience in management, engineering and optimization of databases and infrastructures, especially on Oracle and PostgreSQL. Since the beginning of his career, he has specialized in Oracle Technologies and is Oracle Certified Professional 12c and Oracle Certified Expert RAC\/GridInfra. Over time, Daniel has become increasingly interested in open source technologies, becoming \u201cTechnology Leader Open Infrastructure\u201d and PostgreSQL expert. \u00a0Based on community or EnterpriseDB tools, he develops and installs complex high available solutions with PostgreSQL. He is also a certified PostgreSQL Plus 9.0 Professional and a Postgres Advanced Server 9.4 Professional. He is a regular speaker at PostgreSQL conferences in Switzerland and Europe. Today Daniel is also supporting our customers on AWS services such as AWS RDS, database migrations into the cloud, EC2 and automated infrastructure management with AWS SSM (System Manager). He is a certified AWS Solutions Architect Professional. Prior to dbi services, Daniel was Management System Engineer at LC SYSTEMS-Engineering AG in Basel. Before that, he worked as Oracle Developper &\u00a0Project Manager at Delta Energy Solutions AG in Basel (today Powel AG). Daniel holds a diploma in Business Informatics (DHBW, Germany). His branch-related experience mainly covers the pharma industry, the financial sector, energy, lottery and telecommunications.\",\"sameAs\":[\"https:\/\/x.com\/westermanndanie\"],\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/daniel-westermann\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Schedule reboots of your AWS instances and how that can result in a hard reboot and corruption - dbi Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/schedule-reboots-of-your-aws-instances-and-how-that-can-result-in-a-hard-reboot-and-corruption\/","og_locale":"en_US","og_type":"article","og_title":"Schedule reboots of your AWS instances and how that can result in a hard reboot and corruption","og_description":"From time to time you might require to reboot your AWS instances. Maye you applied some patches or for whatever reason. Rebooting an AWS instance can be done in several ways: You can of course do that directly from the AWS console. You can use the AWS command line utilities as well. If you want […]","og_url":"https:\/\/www.dbi-services.com\/blog\/schedule-reboots-of-your-aws-instances-and-how-that-can-result-in-a-hard-reboot-and-corruption\/","og_site_name":"dbi Blog","article_published_time":"2019-07-17T05:50:41+00:00","og_image":[{"width":663,"height":455,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Selection_074.jpg","type":"image\/jpeg"}],"author":"Daniel Westermann","twitter_card":"summary_large_image","twitter_creator":"@westermanndanie","twitter_misc":{"Written by":"Daniel Westermann","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/schedule-reboots-of-your-aws-instances-and-how-that-can-result-in-a-hard-reboot-and-corruption\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/schedule-reboots-of-your-aws-instances-and-how-that-can-result-in-a-hard-reboot-and-corruption\/"},"author":{"name":"Daniel Westermann","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66"},"headline":"Schedule reboots of your AWS instances and how that can result in a hard reboot and corruption","datePublished":"2019-07-17T05:50:41+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/schedule-reboots-of-your-aws-instances-and-how-that-can-result-in-a-hard-reboot-and-corruption\/"},"wordCount":843,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/schedule-reboots-of-your-aws-instances-and-how-that-can-result-in-a-hard-reboot-and-corruption\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Selection_074.jpg","keywords":["AWS"],"articleSection":["Database Administration & Monitoring"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/schedule-reboots-of-your-aws-instances-and-how-that-can-result-in-a-hard-reboot-and-corruption\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/schedule-reboots-of-your-aws-instances-and-how-that-can-result-in-a-hard-reboot-and-corruption\/","url":"https:\/\/www.dbi-services.com\/blog\/schedule-reboots-of-your-aws-instances-and-how-that-can-result-in-a-hard-reboot-and-corruption\/","name":"Schedule reboots of your AWS instances and how that can result in a hard reboot and corruption - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/schedule-reboots-of-your-aws-instances-and-how-that-can-result-in-a-hard-reboot-and-corruption\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/schedule-reboots-of-your-aws-instances-and-how-that-can-result-in-a-hard-reboot-and-corruption\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Selection_074.jpg","datePublished":"2019-07-17T05:50:41+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/schedule-reboots-of-your-aws-instances-and-how-that-can-result-in-a-hard-reboot-and-corruption\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/schedule-reboots-of-your-aws-instances-and-how-that-can-result-in-a-hard-reboot-and-corruption\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/schedule-reboots-of-your-aws-instances-and-how-that-can-result-in-a-hard-reboot-and-corruption\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Selection_074.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Selection_074.jpg","width":663,"height":455},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/schedule-reboots-of-your-aws-instances-and-how-that-can-result-in-a-hard-reboot-and-corruption\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Schedule reboots of your AWS instances and how that can result in a hard reboot and corruption"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66","name":"Daniel Westermann","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g","caption":"Daniel Westermann"},"description":"Daniel Westermann is Principal Consultant and Technology Leader Open Infrastructure at dbi services. He has more than 15 years of experience in management, engineering and optimization of databases and infrastructures, especially on Oracle and PostgreSQL. Since the beginning of his career, he has specialized in Oracle Technologies and is Oracle Certified Professional 12c and Oracle Certified Expert RAC\/GridInfra. Over time, Daniel has become increasingly interested in open source technologies, becoming \u201cTechnology Leader Open Infrastructure\u201d and PostgreSQL expert. \u00a0Based on community or EnterpriseDB tools, he develops and installs complex high available solutions with PostgreSQL. He is also a certified PostgreSQL Plus 9.0 Professional and a Postgres Advanced Server 9.4 Professional. He is a regular speaker at PostgreSQL conferences in Switzerland and Europe. Today Daniel is also supporting our customers on AWS services such as AWS RDS, database migrations into the cloud, EC2 and automated infrastructure management with AWS SSM (System Manager). He is a certified AWS Solutions Architect Professional. Prior to dbi services, Daniel was Management System Engineer at LC SYSTEMS-Engineering AG in Basel. Before that, he worked as Oracle Developper &\u00a0Project Manager at Delta Energy Solutions AG in Basel (today Powel AG). Daniel holds a diploma in Business Informatics (DHBW, Germany). His branch-related experience mainly covers the pharma industry, the financial sector, energy, lottery and telecommunications.","sameAs":["https:\/\/x.com\/westermanndanie"],"url":"https:\/\/www.dbi-services.com\/blog\/author\/daniel-westermann\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/12634","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/29"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=12634"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/12634\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/12635"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=12634"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=12634"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=12634"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=12634"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}