{"id":16870,"date":"2024-01-18T17:42:37","date_gmt":"2024-01-18T15:42:37","guid":{"rendered":"https:\/\/connectconsulting.be\/aws-aurora-postgress\/"},"modified":"2024-09-05T15:49:45","modified_gmt":"2024-09-05T13:49:45","slug":"aws-aurora-postgress","status":"publish","type":"post","link":"https:\/\/connectconsulting.be\/en\/aws-aurora-postgress\/","title":{"rendered":"AWS Aurora Postgress"},"content":{"rendered":"

We are always looking for interesting topics for our Community evenings. Often, we don’t have to look too far and find them among our Connectors!<\/p>\n

For our last community, we were looking for a current topic that would be of interest to both our Java Developer and DotNet Developer. We ended up on the deployment and implementation of an AWS Aurora PostgresSql database.<\/p>\n

Our Connector, Wouter talked about his real-life experiences on his project related to AWS Aurora PostgresSql database and how they got started with it.<\/p>\n

Why PostgresSql was chosen was because of its pre-existing integration with AWS. Coming from on-prem MS Sql, sql-in-the-cloud seemed the optimal choice, were it not for the big price difference between the two. Through Terraform, they created a new database cluster, this by logging in via Kubectl where they then set up their tables.<\/p>\n

In the end, they chose an AM security with automatic password-rotation. The conscious choice for this was that it made the story more secure. However, it soon turned out that how this worked was a bit more complex after all.<\/p>\n

For one thing, this story only worked in their Kubernetes and they had to look for a local parallel solution. They found this parallel solution in Docker-Compose. On the other hand, they have the issue of dynamic connection strings because of changing passwords. After some research, they ended up with Entity Framework DataSource builders with refresh-callback functionality. This made them migrate to .Net 7, which they eventually did get on with.<\/p>\n","protected":false},"excerpt":{"rendered":"

We are always looking for interesting topics for our Community evenings. Often, we don’t have to look too far and find them among our Connectors! For our last community, we were looking for a current topic that would be of interest to both our Java Developer and DotNet Developer. We…<\/span><\/p>\n","protected":false},"author":2,"featured_media":16603,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[243,244],"tags":[288,247],"class_list":["post-16870","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blog-en","category-ict-en","tag-aws-aurora-postgress-en","tag-connect-consulting-en"],"acf":[],"yoast_head":"\nAWS Aurora Postgress - Connect Consulting - ICT Careers | Infrastructure\/Application<\/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:\/\/connectconsulting.be\/en\/aws-aurora-postgress\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"AWS Aurora Postgress - Connect Consulting - ICT Careers | Infrastructure\/Application\" \/>\n<meta property=\"og:description\" content=\"We are always looking for interesting topics for our Community evenings. Often, we don’t have to look too far and find them among our Connectors! For our last community, we were looking for a current topic that would be of interest to both our Java Developer and DotNet Developer. We...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/connectconsulting.be\/en\/aws-aurora-postgress\/\" \/>\n<meta property=\"og:site_name\" content=\"Connect Consulting - ICT Careers | Infrastructure\/Application\" \/>\n<meta property=\"article:published_time\" content=\"2024-01-18T15:42:37+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-09-05T13:49:45+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/connectconsulting.be\/wp-content\/uploads\/2024\/01\/White-Elegant-Romantic-Photo-Wedding-Thank-You-Card-1024x726.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1024\" \/>\n\t<meta property=\"og:image:height\" content=\"726\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Emilie Cambier\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Emilie Cambier\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/connectconsulting.be\\\/en\\\/aws-aurora-postgress\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/connectconsulting.be\\\/en\\\/aws-aurora-postgress\\\/\"},\"author\":{\"name\":\"Emilie Cambier\",\"@id\":\"https:\\\/\\\/connectconsulting.be\\\/en\\\/#\\\/schema\\\/person\\\/cc2cfe78fceb5d13383b490ab73ad225\"},\"headline\":\"AWS Aurora Postgress\",\"datePublished\":\"2024-01-18T15:42:37+00:00\",\"dateModified\":\"2024-09-05T13:49:45+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/connectconsulting.be\\\/en\\\/aws-aurora-postgress\\\/\"},\"wordCount\":255,\"publisher\":{\"@id\":\"https:\\\/\\\/connectconsulting.be\\\/en\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/connectconsulting.be\\\/en\\\/aws-aurora-postgress\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/connectconsulting.be\\\/wp-content\\\/uploads\\\/2024\\\/01\\\/White-Elegant-Romantic-Photo-Wedding-Thank-You-Card.png\",\"keywords\":[\"AWS Aurora Postgress\",\"Connect Consulting\"],\"articleSection\":[\"Blog\",\"ICT\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/connectconsulting.be\\\/en\\\/aws-aurora-postgress\\\/\",\"url\":\"https:\\\/\\\/connectconsulting.be\\\/en\\\/aws-aurora-postgress\\\/\",\"name\":\"AWS Aurora Postgress - Connect Consulting - ICT Careers | Infrastructure\\\/Application\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/connectconsulting.be\\\/en\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/connectconsulting.be\\\/en\\\/aws-aurora-postgress\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/connectconsulting.be\\\/en\\\/aws-aurora-postgress\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/connectconsulting.be\\\/wp-content\\\/uploads\\\/2024\\\/01\\\/White-Elegant-Romantic-Photo-Wedding-Thank-You-Card.png\",\"datePublished\":\"2024-01-18T15:42:37+00:00\",\"dateModified\":\"2024-09-05T13:49:45+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/connectconsulting.be\\\/en\\\/aws-aurora-postgress\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/connectconsulting.be\\\/en\\\/aws-aurora-postgress\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/connectconsulting.be\\\/en\\\/aws-aurora-postgress\\\/#primaryimage\",\"url\":\"https:\\\/\\\/connectconsulting.be\\\/wp-content\\\/uploads\\\/2024\\\/01\\\/White-Elegant-Romantic-Photo-Wedding-Thank-You-Card.png\",\"contentUrl\":\"https:\\\/\\\/connectconsulting.be\\\/wp-content\\\/uploads\\\/2024\\\/01\\\/White-Elegant-Romantic-Photo-Wedding-Thank-You-Card.png\",\"width\":1748,\"height\":1240},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/connectconsulting.be\\\/en\\\/aws-aurora-postgress\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/connectconsulting.be\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"AWS Aurora Postgress\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/connectconsulting.be\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/connectconsulting.be\\\/en\\\/\",\"name\":\"Connect Consulting - ICT Careers | Infrastructure\\\/Application\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/connectconsulting.be\\\/en\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/connectconsulting.be\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/connectconsulting.be\\\/en\\\/#organization\",\"name\":\"Connect Consulting - ICT Careers | Infrastructure\\\/Application\",\"url\":\"https:\\\/\\\/connectconsulting.be\\\/en\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/connectconsulting.be\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/connectconsulting.be\\\/wp-content\\\/uploads\\\/2023\\\/03\\\/logo-black.png\",\"contentUrl\":\"https:\\\/\\\/connectconsulting.be\\\/wp-content\\\/uploads\\\/2023\\\/03\\\/logo-black.png\",\"width\":268,\"height\":118,\"caption\":\"Connect Consulting - ICT Careers | Infrastructure\\\/Application\"},\"image\":{\"@id\":\"https:\\\/\\\/connectconsulting.be\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/connectconsulting.be\\\/en\\\/#\\\/schema\\\/person\\\/cc2cfe78fceb5d13383b490ab73ad225\",\"name\":\"Emilie Cambier\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"AWS Aurora Postgress - Connect Consulting - ICT Careers | Infrastructure\/Application","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:\/\/connectconsulting.be\/en\/aws-aurora-postgress\/","og_locale":"en_US","og_type":"article","og_title":"AWS Aurora Postgress - Connect Consulting - ICT Careers | Infrastructure\/Application","og_description":"We are always looking for interesting topics for our Community evenings. Often, we don’t have to look too far and find them among our Connectors! For our last community, we were looking for a current topic that would be of interest to both our Java Developer and DotNet Developer. We...","og_url":"https:\/\/connectconsulting.be\/en\/aws-aurora-postgress\/","og_site_name":"Connect Consulting - ICT Careers | Infrastructure\/Application","article_published_time":"2024-01-18T15:42:37+00:00","article_modified_time":"2024-09-05T13:49:45+00:00","og_image":[{"width":1024,"height":726,"url":"https:\/\/connectconsulting.be\/wp-content\/uploads\/2024\/01\/White-Elegant-Romantic-Photo-Wedding-Thank-You-Card-1024x726.png","type":"image\/png"}],"author":"Emilie Cambier","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Emilie Cambier","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/connectconsulting.be\/en\/aws-aurora-postgress\/#article","isPartOf":{"@id":"https:\/\/connectconsulting.be\/en\/aws-aurora-postgress\/"},"author":{"name":"Emilie Cambier","@id":"https:\/\/connectconsulting.be\/en\/#\/schema\/person\/cc2cfe78fceb5d13383b490ab73ad225"},"headline":"AWS Aurora Postgress","datePublished":"2024-01-18T15:42:37+00:00","dateModified":"2024-09-05T13:49:45+00:00","mainEntityOfPage":{"@id":"https:\/\/connectconsulting.be\/en\/aws-aurora-postgress\/"},"wordCount":255,"publisher":{"@id":"https:\/\/connectconsulting.be\/en\/#organization"},"image":{"@id":"https:\/\/connectconsulting.be\/en\/aws-aurora-postgress\/#primaryimage"},"thumbnailUrl":"https:\/\/connectconsulting.be\/wp-content\/uploads\/2024\/01\/White-Elegant-Romantic-Photo-Wedding-Thank-You-Card.png","keywords":["AWS Aurora Postgress","Connect Consulting"],"articleSection":["Blog","ICT"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/connectconsulting.be\/en\/aws-aurora-postgress\/","url":"https:\/\/connectconsulting.be\/en\/aws-aurora-postgress\/","name":"AWS Aurora Postgress - Connect Consulting - ICT Careers | Infrastructure\/Application","isPartOf":{"@id":"https:\/\/connectconsulting.be\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/connectconsulting.be\/en\/aws-aurora-postgress\/#primaryimage"},"image":{"@id":"https:\/\/connectconsulting.be\/en\/aws-aurora-postgress\/#primaryimage"},"thumbnailUrl":"https:\/\/connectconsulting.be\/wp-content\/uploads\/2024\/01\/White-Elegant-Romantic-Photo-Wedding-Thank-You-Card.png","datePublished":"2024-01-18T15:42:37+00:00","dateModified":"2024-09-05T13:49:45+00:00","breadcrumb":{"@id":"https:\/\/connectconsulting.be\/en\/aws-aurora-postgress\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/connectconsulting.be\/en\/aws-aurora-postgress\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/connectconsulting.be\/en\/aws-aurora-postgress\/#primaryimage","url":"https:\/\/connectconsulting.be\/wp-content\/uploads\/2024\/01\/White-Elegant-Romantic-Photo-Wedding-Thank-You-Card.png","contentUrl":"https:\/\/connectconsulting.be\/wp-content\/uploads\/2024\/01\/White-Elegant-Romantic-Photo-Wedding-Thank-You-Card.png","width":1748,"height":1240},{"@type":"BreadcrumbList","@id":"https:\/\/connectconsulting.be\/en\/aws-aurora-postgress\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/connectconsulting.be\/en\/"},{"@type":"ListItem","position":2,"name":"AWS Aurora Postgress"}]},{"@type":"WebSite","@id":"https:\/\/connectconsulting.be\/en\/#website","url":"https:\/\/connectconsulting.be\/en\/","name":"Connect Consulting - ICT Careers | Infrastructure\/Application","description":"","publisher":{"@id":"https:\/\/connectconsulting.be\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/connectconsulting.be\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/connectconsulting.be\/en\/#organization","name":"Connect Consulting - ICT Careers | Infrastructure\/Application","url":"https:\/\/connectconsulting.be\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/connectconsulting.be\/en\/#\/schema\/logo\/image\/","url":"https:\/\/connectconsulting.be\/wp-content\/uploads\/2023\/03\/logo-black.png","contentUrl":"https:\/\/connectconsulting.be\/wp-content\/uploads\/2023\/03\/logo-black.png","width":268,"height":118,"caption":"Connect Consulting - ICT Careers | Infrastructure\/Application"},"image":{"@id":"https:\/\/connectconsulting.be\/en\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/connectconsulting.be\/en\/#\/schema\/person\/cc2cfe78fceb5d13383b490ab73ad225","name":"Emilie Cambier"}]}},"_links":{"self":[{"href":"https:\/\/connectconsulting.be\/en\/wp-json\/wp\/v2\/posts\/16870","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/connectconsulting.be\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/connectconsulting.be\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/connectconsulting.be\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/connectconsulting.be\/en\/wp-json\/wp\/v2\/comments?post=16870"}],"version-history":[{"count":2,"href":"https:\/\/connectconsulting.be\/en\/wp-json\/wp\/v2\/posts\/16870\/revisions"}],"predecessor-version":[{"id":19204,"href":"https:\/\/connectconsulting.be\/en\/wp-json\/wp\/v2\/posts\/16870\/revisions\/19204"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/connectconsulting.be\/en\/wp-json\/wp\/v2\/media\/16603"}],"wp:attachment":[{"href":"https:\/\/connectconsulting.be\/en\/wp-json\/wp\/v2\/media?parent=16870"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/connectconsulting.be\/en\/wp-json\/wp\/v2\/categories?post=16870"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/connectconsulting.be\/en\/wp-json\/wp\/v2\/tags?post=16870"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}