{"id":2507,"date":"2023-01-12T12:06:38","date_gmt":"2023-01-12T12:06:38","guid":{"rendered":"https:\/\/www.easydeploy.io\/blog\/?p=2507"},"modified":"2023-03-29T13:01:31","modified_gmt":"2023-03-29T12:01:31","slug":"upgrade-amazon-aurora-postgresql-latest-version","status":"publish","type":"post","link":"https:\/\/www.easydeploy.io\/blog\/upgrade-amazon-aurora-postgresql-latest-version\/","title":{"rendered":"How upgrade Amazon Aurora PostgreSQL latest version with zero to minimal downtime using AWS DMS"},"content":{"rendered":"<p>In our previous blog, we could see how to<strong><a href=\"https:\/\/www.easydeploy.io\/blog\/upgrade-mysql-version-rds-using-aws-dms\/\" target=\"_blank\" rel=\"noopener\"> upgrade the RDS MySQL version to the latest version<\/a> with zero downtime using AWS DMS<\/strong>.<\/p>\n<p>In this blog, we are going to discuss upgrading the Amazon <strong>Aurora PostgreSQL<\/strong> version from <strong>10.21 to the latest version(for now 14.5)<\/strong> using <strong>DMS.<\/strong><\/p>\n<p>We just follow the same but little different procedure from the previous blog to complete this requirement.<\/p>\n<h2>Create Parameter Groups<\/h2>\n<p><span>Open your AWS console and search for\u00a0<strong>RDS<\/strong>\u00a0and click it.<\/span><\/p>\n<p><span>On the left side of the\u00a0<strong>RDS<\/strong> page, you can see\u00a0<strong>parameter groups.<\/strong> Enter the section and Click <strong>Create parameter group<\/strong>\u00a0button in the top right corner of the page.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/1.webp\" alt=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Create parameter group\" width=\"1877\" height=\"593\" class=\"aligncenter wp-image-2442 size-full\" title=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Create parameter group\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/1.webp 1877w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/1-300x95.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/1-1024x324.webp 1024w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/1-768x243.webp 768w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/1-1536x485.webp 1536w\" sizes=\"(max-width: 1877px) 100vw, 1877px\" \/><\/p>\n<ul>\n<li>First, we have to create a parameter group for aurora PostgreSQL version 10 for an old version of the database.<\/li>\n<li><span>Choose the\u00a0<strong>Parameter group family<\/strong>\u00a0to <strong>aurora-postgresql10.<\/strong><\/span><\/li>\n<li><span>Enter the <strong>Group name<\/strong>\u00a0to\u00a0<strong>cluster-aurora-postgresql10<\/strong> or whatever you want to provide at your convenience.<\/span><\/li>\n<li><span>Then provide a\u00a0<strong>description<\/strong> of the parameter group then click\u00a0<strong>Create.<\/strong><\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/2.webp\" alt=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Create parameter group\" width=\"643\" height=\"458\" class=\"aligncenter wp-image-2443\" title=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Create parameter group\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/2.webp 1098w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/2-300x214.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/2-1024x729.webp 1024w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/2-768x547.webp 768w\" sizes=\"(max-width: 643px) 100vw, 643px\" \/><\/p>\n<p>Now select the parameter group you just created, and click <strong>Parameter group actions -&gt; Edit<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/3.webp\" alt=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Edit parameter group\" width=\"1222\" height=\"310\" class=\"aligncenter wp-image-2444 size-full\" title=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Edit parameter group\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/3.webp 1222w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/3-300x76.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/3-1024x260.webp 1024w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/3-768x195.webp 768w\" sizes=\"(max-width: 1222px) 100vw, 1222px\" \/><\/p>\n<p>Search for the following parameters and change their values of them with the below values like the screenshots below.<\/p>\n<ul>\n<li><strong>rds.logical_replication\u00a0 \u00a0 \u00a0 \u00a0 = 1<\/strong><\/li>\n<li><strong>wal_sender_timeout\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0= 0<\/strong><\/li>\n<li><strong>rds.log_retention_period\u00a0 \u00a0= 7200<\/strong><\/li>\n<li><strong>max_replication_slots\u00a0 \u00a0 \u00a0 \u00a0 = 20<\/strong><\/li>\n<li><strong>session_replication_role\u00a0 \u00a0 = replica <\/strong><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/4.webp\" alt=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Edit Logical Replication\" width=\"1497\" height=\"357\" class=\"aligncenter wp-image-2445 size-full\" title=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Edit Logical Replication\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/4.webp 1497w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/4-300x72.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/4-1024x244.webp 1024w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/4-768x183.webp 768w\" sizes=\"(max-width: 1497px) 100vw, 1497px\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/5.webp\" alt=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Edit Wal Sender Timeout\" width=\"595\" height=\"313\" class=\"wp-image-2446 aligncenter\" title=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Edit Wal Sender Timeout\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/5.webp 746w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/5-300x158.webp 300w\" sizes=\"(max-width: 595px) 100vw, 595px\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/6.webp\" alt=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Edit Log Retention Period\" width=\"570\" height=\"296\" class=\"aligncenter wp-image-2447\" title=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Edit Log Retention Period\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/6.webp 728w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/6-300x156.webp 300w\" sizes=\"(max-width: 570px) 100vw, 570px\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/7.webp\" alt=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Edit Max Replication Slots\" width=\"445\" height=\"299\" class=\"wp-image-2448 aligncenter\" title=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Edit Max Replication Slots\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/7.webp 606w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/7-300x201.webp 300w\" sizes=\"(max-width: 445px) 100vw, 445px\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/8-e1672909881280.webp\" alt=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Edit Session Replication Role\" width=\"642\" height=\"358\" class=\"aligncenter wp-image-2449\" title=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Edit Session Replication Role\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/8-e1672909881280.webp 1184w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/8-e1672909881280-300x167.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/8-e1672909881280-1024x571.webp 1024w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/8-e1672909881280-768x428.webp 768w\" sizes=\"(max-width: 642px) 100vw, 642px\" \/><\/p>\n<p>Once completed all changes in the parameters click the <strong>Preview changes<\/strong> button like the above picture to view the changes.<\/p>\n<p>You can see the changes in the parameters, click <strong>Save changes.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/9.webp\" alt=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Preview Changes\" width=\"693\" height=\"348\" class=\"aligncenter wp-image-2450\" title=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Preview Changes\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/9.webp 1038w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/9-300x151.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/9-1024x514.webp 1024w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/9-768x385.webp 768w\" sizes=\"(max-width: 693px) 100vw, 693px\" \/><\/p>\n<p>Create another parameter group for Aurora PostgreSQL version 14 for the latest version.<\/p>\n<ul>\n<li><span>Choose the\u00a0<strong>Parameter group family<\/strong>\u00a0to <strong>aurora-postgresql14.<\/strong><\/span><\/li>\n<li><span>Enter the <strong>Group name<\/strong>\u00a0to\u00a0<strong>cluster-aurora-postgresql14<\/strong> or whatever you want to provide at your convenience.<\/span><\/li>\n<li><span>Then provide a\u00a0<strong>description<\/strong> of the parameter group then click\u00a0<strong>Create.<\/strong><\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/10.webp\" alt=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Create Parameter Group Latest version\" width=\"732\" height=\"528\" class=\"aligncenter wp-image-2451\" title=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Create Parameter Group Latest version\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/10.webp 1047w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/10-300x216.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/10-1024x738.webp 1024w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/10-768x554.webp 768w\" sizes=\"(max-width: 732px) 100vw, 732px\" \/><\/p>\n<p>Select the Parameter group for the latest PostgreSQL version and click <strong>Parameter group actions -&gt; Edit.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/11.webp\" alt=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Edit Parameter Group Latest version\" width=\"1201\" height=\"336\" class=\"aligncenter wp-image-2452 size-full\" title=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Edit Parameter Group Latest version\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/11.webp 1201w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/11-300x84.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/11-1024x286.webp 1024w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/11-768x215.webp 768w\" sizes=\"(max-width: 1201px) 100vw, 1201px\" \/><\/p>\n<p>Change the following parameters&#8217; values and click <strong>Save changes.<\/strong><\/p>\n<ul>\n<li><strong>rds.logical_replication\u00a0 \u00a0 \u00a0 \u00a0 = 1<\/strong><\/li>\n<li><strong>wal_sender_timeout\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0= 0<\/strong><\/li>\n<li><strong>rds.log_retention_period\u00a0 \u00a0= 7200<\/strong><\/li>\n<li><strong>max_replication_slots\u00a0 \u00a0 \u00a0 \u00a0 = 20<\/strong><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/12.webp\" alt=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Preview CHnages Parameter Group Latest version\" width=\"822\" height=\"376\" class=\"aligncenter wp-image-2453\" title=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Preview CHnages Parameter Group Latest version\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/12.webp 1033w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/12-300x137.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/12-1024x468.webp 1024w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/12-768x351.webp 768w\" sizes=\"(max-width: 822px) 100vw, 822px\" \/><\/p>\n<h2>Create Aurora PostgreSQL DB Clusters<\/h2>\n<h3>Aurora PostgreSQL DB Cluster with version 10.21<\/h3>\n<p><span>On the left navigation section under the\u00a0<\/span><strong>Amazon RDS<\/strong><span>\u00a0Click the\u00a0<\/span><strong>Databases<\/strong><span>\u00a0section followed by\u00a0<\/span><strong>Create database.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/13.webp\" alt=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Create Source Database\" width=\"1863\" height=\"387\" class=\"aligncenter wp-image-2454 size-full\" title=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Create Source Database\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/13.webp 1863w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/13-300x62.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/13-1024x213.webp 1024w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/13-768x160.webp 768w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/13-1536x319.webp 1536w\" sizes=\"(max-width: 1863px) 100vw, 1863px\" \/><\/p>\n<p><span>Select the\u00a0<strong>standard create<\/strong>\u00a0option.\u00a0<\/span><span>For the Engine choose the <strong>Amazon Aurora engine.<\/strong><\/span><\/p>\n<p>For <strong>Edition<\/strong> choose <strong><a href=\"https:\/\/docs.aws.amazon.com\/AmazonRDS\/latest\/AuroraUserGuide\/Aurora.AuroraPostgreSQL.html\" target=\"_blank\" rel=\"noopener\">Amazon Aurora PostgreSQL<\/a>-Compatible Edition<\/strong>.<\/p>\n<p>And for the <strong>Available versions<\/strong>, choose an <strong>old version<\/strong> that is available at the time when you working. For now, we select <strong>PostgreSQL 10.21<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/14.webp\" alt=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Choose Engine Source Database\" width=\"602\" height=\"846\" class=\"aligncenter wp-image-2455\" title=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Choose Engine Source Database\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/14.webp 491w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/14-213x300.webp 213w\" sizes=\"(max-width: 602px) 100vw, 602px\" \/><\/p>\n<p><span>For\u00a0<\/span><strong>Templates<\/strong><span>\u00a0choose the\u00a0<\/span><strong>Free tier<\/strong><span>\u00a0section. It will reduce the cost for creating a database. Here we are going to create a database for testing purposes only. So free tier is enough for now.<\/span><\/p>\n<p><span>Under\u00a0<strong>Settings,<\/strong>\u00a0for\u00a0<strong>DB instance identifier<\/strong>, provide a name like <strong>source-cluster<\/strong> for your database instance.<\/span><\/p>\n<p>For\u00a0<strong>master username<\/strong>\u00a0enter\u00a0<b><i>postgres <\/i><\/b>and\u00a0<strong>Master password<\/strong>\u00a0provide a password for your database username and type the\u00a0<strong>password again<\/strong>\u00a0for confirmation.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/15.webp\" alt=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Settings Source Database\" width=\"632\" height=\"735\" class=\"aligncenter wp-image-2456 size-full\" title=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Settings Source Database\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/15.webp 632w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/15-258x300.webp 258w\" sizes=\"(max-width: 632px) 100vw, 632px\" \/><\/p>\n<p><span>Under the\u00a0<strong>Instance configuration,<\/strong>\u00a0for\u00a0<strong>DB Instance class<\/strong>\u00a0select <strong>Burstable classes<\/strong> and choose the least size for this demo.<\/span><\/p>\n<p>For\u00a0<b>Availability\u00a0&amp; durability <\/b>choose\u00a0<b>Don&#8217;t create an Aurora Replica<\/b>.<\/p>\n<ul>\n<li>If you choose the other one it will create a new reader instance in a different availability zone for scalable and high availability. It will <strong>cost higher<\/strong> than the first option.<\/li>\n<li>In production scenarios, we should follow the Aurora Replica creation method for high availability. But for now, just run with a single instance.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/16.webp\" alt=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Configurations Source Database\" width=\"741\" height=\"501\" class=\"aligncenter wp-image-2457\" title=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Configurations Source Database\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/16.webp 862w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/16-300x203.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/16-768x519.webp 768w\" sizes=\"(max-width: 741px) 100vw, 741px\" \/><\/p>\n<ul>\n<li><span>For the\u00a0<strong>Connectivity<\/strong> section, first, select the <strong>Don\u2019t connect to an EC2 compute resource<\/strong>\u00a0option. We can configure it later.<\/span><\/li>\n<li><span>Next, the <strong>network-type<\/strong> chooses\u00a0<strong>IPv4,<\/strong>\u00a0and\u00a0<strong>VPC,<\/strong> and choose any\u00a0<strong>VPC<\/strong> you want to use. For myself, I choose the <strong>default<\/strong>\u00a0one.<\/span><\/li>\n<li><span>For the\u00a0<strong>DB subnet group<\/strong>\u00a0select\u00a0<strong>default.<\/strong><\/span><\/li>\n<li><span>For\u00a0<strong>Public access,<\/strong>\u00a0choose\u00a0<strong>yes.<\/strong>\u00a0Then only we can connect with our database from outside of the VPC.<\/span><\/li>\n<li><span>Then for the\u00a0<strong>Security group<\/strong>\u00a0select the\u00a0<strong>Create new<\/strong>\u00a0option and provide a Name for it.<\/span><\/li>\n<li><span>And choose any of the availability zones that you want.<\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/17.webp\" alt=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Connectivity Source Database\" width=\"666\" height=\"875\" class=\"aligncenter wp-image-2458\" title=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Connectivity Source Database\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/17.webp 630w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/17-228x300.webp 228w\" sizes=\"(max-width: 666px) 100vw, 666px\" \/><\/p>\n<p><span>Scroll down and expand the\u00a0<strong>Additional configuration<\/strong>\u00a0section.<\/span><\/p>\n<p>For the <strong>Initial database name,<\/strong> enter a name for the database.<\/p>\n<p><span>Under the\u00a0<strong>DB parameter group<\/strong> choose the parameter group which you create at the beginning of this tutorial for <strong>Aurora PostgreSQL version 10<\/strong>.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/18.webp\" alt=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Select Parameter Group Source Database\" width=\"614\" height=\"387\" class=\"aligncenter wp-image-2459\" title=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Select Parameter Group Source Database\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/18.webp 853w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/18-300x189.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/18-768x484.webp 768w\" sizes=\"(max-width: 614px) 100vw, 614px\" \/><\/p>\n<p>Leave all other things as default, then click <strong>Create database.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/19.webp\" alt=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Default Source Database\" width=\"609\" height=\"1007\" class=\"aligncenter wp-image-2460\" title=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Default Source Database\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/19.webp 510w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/19-181x300.webp 181w\" sizes=\"(max-width: 609px) 100vw, 609px\" \/><\/p>\n<p>Now the source database cluster is created with a database instance.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/20.webp\" alt=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Creating Source Database Cluster\" width=\"1543\" height=\"502\" class=\"aligncenter wp-image-2461 size-full\" title=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Creating Source Database Cluster\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/20.webp 1543w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/20-300x98.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/20-1024x333.webp 1024w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/20-768x250.webp 768w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/20-1536x500.webp 1536w\" sizes=\"(max-width: 1543px) 100vw, 1543px\" \/><\/p>\n<h2>Aurora PostgreSQL DB Cluster with the latest version<\/h2>\n<p>Again we are going to create a PostgreSQL database cluster with the latest version. So click <strong>Create database.<\/strong><\/p>\n<p>For <strong>Engine type<\/strong>, choose <strong>Amazon Aurora.<\/strong><\/p>\n<p>For <strong>Edition<\/strong> choose <strong>Amazon Aurora PostgreSQL-Compatible Edition<\/strong>.<\/p>\n<p>And for the <strong>Available versions<\/strong>, choose the <strong>latest version<\/strong> which is available at the time when you working. For now, we select <strong>PostgreSQL 14.5<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/21.webp\" alt=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Choose Engine Target Database\" width=\"760\" height=\"810\" class=\"aligncenter wp-image-2462 size-full\" title=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Choose Engine Target Database\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/21.webp 760w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/21-281x300.webp 281w\" sizes=\"(max-width: 760px) 100vw, 760px\" \/><\/p>\n<p>Choose <strong>Dev\/Test<\/strong> for <strong>Templates<\/strong> section.<\/p>\n<p>Under Settings, fill in all the things like the below screenshot.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/22.webp\" alt=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Settings Target Database\" width=\"631\" height=\"732\" class=\"aligncenter wp-image-2463 size-full\" title=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Settings Target Database\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/22.webp 631w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/22-259x300.webp 259w\" sizes=\"(max-width: 631px) 100vw, 631px\" \/><\/p>\n<p>For<strong> instance class<\/strong> choose <strong>Burstable classes<\/strong> for this demo purpose and for the <strong>Multi-AZ deployment<\/strong>, choose <strong>Don&#8217;t create an Aurora Replica<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/23.webp\" alt=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS System Config Target Database\" width=\"732\" height=\"523\" class=\"aligncenter wp-image-2464\" title=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS System Config Target Database\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/23.webp 947w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/23-300x214.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/23-768x549.webp 768w\" sizes=\"(max-width: 732px) 100vw, 732px\" \/><\/p>\n<p>Choose a VPC which you select for the old version database cluster for <strong>VPC.\u00a0<\/strong>Follow the same for the DB Subnet group.<\/p>\n<p>Click <strong>Yes<\/strong> for <strong>Public access.<\/strong><\/p>\n<p>For the <strong>VPC security group<\/strong>, click <strong>Choose existing\u00a0<\/strong>and choose the security group which is created by the previous database.<\/p>\n<p>And finally, for the <strong>Availability zone<\/strong>, choose the same availability zone in which you created your old version database cluster.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/24.webp\" alt=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Connectivity Target Database\" width=\"758\" height=\"790\" class=\"aligncenter wp-image-2465 size-full\" title=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Connectivity Target Database\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/24.webp 758w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/24-288x300.webp 288w\" sizes=\"(max-width: 758px) 100vw, 758px\" \/><\/p>\n<p>Under the <strong>Additional configuration,<\/strong> Enter a database name for <strong>Initial database name<\/strong> and for the <strong>DB cluster parameter group<\/strong>, choose the parameter group you created earlier for the <strong>latest PostgreSQL version<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/25.webp\" alt=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Parameter Group Target Database\" width=\"813\" height=\"462\" class=\"aligncenter wp-image-2466 size-full\" title=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Parameter Group Target Database\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/25.webp 813w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/25-300x170.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/25-768x436.webp 768w\" sizes=\"(max-width: 813px) 100vw, 813px\" \/><\/p>\n<p>Leave all others as default and click <strong>Create database.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/26.webp\" alt=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Create Target Database\" width=\"676\" height=\"441\" class=\"aligncenter wp-image-2467\" title=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Create Target Database\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/26.webp 777w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/26-300x196.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/26-768x501.webp 768w\" sizes=\"(max-width: 676px) 100vw, 676px\" \/><\/p>\n<p>Now the second DB cluster with a DB instance also creating. Let them complete the creation.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/27.webp\" alt=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Creating Source and Target Databases\" width=\"1517\" height=\"595\" class=\"aligncenter wp-image-2468 size-full\" title=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Creating Source and Target Databases\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/27.webp 1517w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/27-300x118.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/27-1024x402.webp 1024w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/27-768x301.webp 768w\" sizes=\"(max-width: 1517px) 100vw, 1517px\" \/><\/p>\n<h2>Modify the Security group, Inbound Rule<\/h2>\n<p>In the meantime, let&#8217;s modify the Inbound rule in the security group of our database.<\/p>\n<p>Go to the <strong>VPC<\/strong> section in the AWS console and select <strong>Security groups<\/strong> in the left navigation section.<\/p>\n<p>Choose the security group that you created with the database and select <strong>Inbound rules<\/strong> and click Edit inbound rules.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/28.webp\" alt=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Edit DB Security Group\" width=\"1857\" height=\"797\" class=\"aligncenter wp-image-2469 size-full\" title=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Edit DB Security Group\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/28.webp 1857w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/28-300x129.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/28-1024x439.webp 1024w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/28-768x330.webp 768w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/28-1536x659.webp 1536w\" sizes=\"(max-width: 1857px) 100vw, 1857px\" \/><\/p>\n<p>Change the <strong>Source<\/strong> to <strong>Anywhere<\/strong> and add &#8216;<strong>0.0.0.0\/0&#8242;<\/strong> like the picture below. Then click <strong>Save rules.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/29.webp\" alt=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Edit DB Security Group Inbound Rule\" width=\"1797\" height=\"591\" class=\"aligncenter wp-image-2470 size-full\" title=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Edit DB Security Group Inbound Rule\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/29.webp 1797w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/29-300x99.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/29-1024x337.webp 1024w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/29-768x253.webp 768w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/29-1536x505.webp 1536w\" sizes=\"(max-width: 1797px) 100vw, 1797px\" \/><\/p>\n<h2>Create Table in Source Database<\/h2>\n<p>Navigate to the RDS Databases section and you can see all the DB clusters and the DB Instances are created successfully.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/30.webp\" alt=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Source DB status Available\" width=\"1497\" height=\"490\" class=\"aligncenter wp-image-2471 size-full\" title=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Source DB status Available\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/30.webp 1497w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/30-300x98.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/30-1024x335.webp 1024w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/30-768x251.webp 768w\" sizes=\"(max-width: 1497px) 100vw, 1497px\" \/><\/p>\n<p>Select the <strong>Source DB Cluster,\u00a0<\/strong>under the Configuration section, You can see the Engine version. So you can confirm this Db cluster is the older version of PostgreSQL.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/31a.webp\" alt=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Source DB Configuration\" width=\"1515\" height=\"787\" class=\"aligncenter wp-image-2473 size-full\" title=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Source DB Configuration\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/31a.webp 1515w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/31a-300x156.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/31a-1024x532.webp 1024w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/31a-768x399.webp 768w\" sizes=\"(max-width: 1515px) 100vw, 1515px\" \/><\/p>\n<p>Select the <strong>Source DB Cluster,\u00a0<\/strong>under the <strong>Connectivity &amp; security<\/strong> section, you can find the <strong>endpoints<\/strong> of your DB Cluster.<\/p>\n<p>Copy the <strong>endpoint<\/strong> for the <strong>Writer instance<\/strong> and note it somewhere else.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/31.webp\" alt=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Source DB Endpoints\" width=\"1540\" height=\"757\" class=\"aligncenter wp-image-2472 size-full\" title=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Source DB Endpoints\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/31.webp 1540w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/31-300x147.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/31-1024x503.webp 1024w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/31-768x378.webp 768w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/31-1536x755.webp 1536w\" sizes=\"(max-width: 1540px) 100vw, 1540px\" \/><\/p>\n<p><span>Connect to your\u00a0<\/span><strong>EC2<\/strong><span>\u00a0instance via\u00a0<\/span><strong>SSH<\/strong><span> connection and log in as a\u00a0<\/span><strong>root<\/strong><span>\u00a0user.<\/span><\/p>\n<p>This Instance is should be in the same VPC as this DB cluster.<\/p>\n<p><span>Then run the following command with your <strong>source DB Cluster Endpoint<\/strong>.<\/span><\/p>\n<pre>psql --host=&lt;source_db_endpoint&gt; --port=5432 --username=&lt;db_username&gt; --password --dbname=&lt;db_name&gt;<\/pre>\n<p>It prompts for a password for the db user.<\/p>\n<p>Enter the following commands to create a table called &#8216;<strong>COMPANY<\/strong>&#8216; and insert a row of data into the table.<\/p>\n<pre>CREATE TABLE COMPANY(\r\nID INT PRIMARY KEY NOT NULL,\r\nNAME TEXT NOT NULL,\r\nAGE INT NOT NULL,\r\nADDRESS CHAR(50),\r\nSALARY REAL\r\n);\r\n\r\nINSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY) VALUES (1, 'Paul', 32, 'California', 20000.00);<\/pre>\n<p>Run the <strong>&#8216;\\d<\/strong>&#8216; command to list the tables inside the database.<\/p>\n<p>Run the below command to see the contents of the table.<\/p>\n<pre>select * from COMPANY;<\/pre>\n<p>Run the command &#8216;<strong>exit;<\/strong>&#8216; to exit from the database.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/32.webp\" alt=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Login to Source PostgreSQL DB Create Table\" width=\"1682\" height=\"663\" class=\"aligncenter wp-image-2474 size-full\" title=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Login to Source PostgreSQL DB Create Table\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/32.webp 1682w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/32-300x118.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/32-1024x404.webp 1024w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/32-768x303.webp 768w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/32-1536x605.webp 1536w\" sizes=\"(max-width: 1682px) 100vw, 1682px\" \/><\/p>\n<p>Now select the <strong>target DB cluster,\u00a0<\/strong>and under the <strong>Configuration <\/strong>section, you can find the database version. For this scenario latest version of <strong>PostgreSQL<\/strong> is <strong>14.5.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/34a.webp\" alt=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Target DB Configuration\" width=\"1513\" height=\"807\" class=\"aligncenter wp-image-2477 size-full\" title=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Target DB Configuration\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/34a.webp 1513w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/34a-300x160.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/34a-1024x546.webp 1024w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/34a-768x410.webp 768w\" sizes=\"(max-width: 1513px) 100vw, 1513px\" \/><\/p>\n<p>Under the\u00a0<strong>Connectivity &amp; security\u00a0<\/strong>section, copy the <strong>Endpoint<\/strong> for the type of\u00a0<strong>Writer\u00a0<\/strong><b>Instance.<\/b><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/34.webp\" alt=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Target DB Endpoints\" width=\"1523\" height=\"752\" class=\"aligncenter wp-image-2476 size-full\" title=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Target DB Endpoints\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/34.webp 1523w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/34-300x148.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/34-1024x506.webp 1024w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/34-768x379.webp 768w\" sizes=\"(max-width: 1523px) 100vw, 1523px\" \/><\/p>\n<p>Login into the target database with the following command.<\/p>\n<p>For target_db_endpoint, enter the endpoint name of the target cluster.<\/p>\n<pre>psql --host=&lt;target_db_endpoint&gt; --port=5432 --username=&lt;db_username&gt; --password --dbname=&lt;db_name&gt;<\/pre>\n<p>Run the &#8216;<strong>\\d<\/strong>&#8216; command to see the list of tables. You cannot able to find any table in the target database. Because right now we don&#8217;t creates any tables here.<\/p>\n<p>So run the &#8216;<strong>exit<\/strong>&#8216; command to log out from the target database.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/35.webp\" alt=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Login to Target PostgreSQL DB\" width=\"1687\" height=\"247\" class=\"aligncenter wp-image-2478 size-full\" title=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Login to Target PostgreSQL DB\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/35.webp 1687w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/35-300x44.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/35-1024x150.webp 1024w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/35-768x112.webp 768w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/35-1536x225.webp 1536w\" sizes=\"(max-width: 1687px) 100vw, 1687px\" \/><\/p>\n<h2><span id=\"Database_Migration_Service\">Database Migration Service<\/span><\/h2>\n<p>Now we are going to migrate the Source Database to the Target database using DMS.<\/p>\n<p>We now follow the same procedure as the previous blog.<em><\/em><\/p>\n<h3>Create Replication Instance<\/h3>\n<p>Click the below link and follow the process to create a <strong>Replication Instance<\/strong> for Database Migration Process.<\/p>\n<pre><em><strong><a href=\"https:\/\/www.easydeploy.io\/blog\/upgrade-mysql-version-rds-using-aws-dms\/#Create_Replication_Instance\">Link for creating replication instance<\/a><\/strong><\/em><\/pre>\n<p>For the creation of the replication instance, time will take around <strong>10<\/strong> to <strong>15 minutes.<\/strong> Wait until the creation is completed.<\/p>\n<h3><span id=\"Create_Source_and_Target_Endpoints\">Create Source and Target Endpoints<\/span><\/h3>\n<p>Once the replication instance is created click the <strong>Endpoints<\/strong> in the left navigation section and then click <strong>Create endpoint.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/42.webp\" alt=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Create Endpoints\" width=\"1877\" height=\"605\" class=\"aligncenter wp-image-2485 size-full\" title=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Create Endpoints\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/42.webp 1877w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/42-300x97.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/42-1024x330.webp 1024w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/42-768x248.webp 768w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/42-1536x495.webp 1536w\" sizes=\"(max-width: 1877px) 100vw, 1877px\" \/><\/p>\n<p>For <strong>endpoint type<\/strong> choose <strong>Source endpoint<\/strong> and check <strong>right<\/strong> for <strong>Select RDS DB instance.<\/strong><\/p>\n<p>For RDS Instance, choose the <strong>source DB cluster<\/strong> with the <strong>old PostgreSQL version<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/43.webp\" alt=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Choose Source Endpoint\" width=\"768\" height=\"382\" class=\"aligncenter wp-image-2486\" title=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Choose Source Endpoint\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/43.webp 1032w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/43-300x149.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/43-1024x509.webp 1024w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/43-768x382.webp 768w\" sizes=\"(max-width: 768px) 100vw, 768px\" \/><\/p>\n<ul>\n<li>Under the\u00a0<strong>Endpoint configuration,\u00a0<\/strong>for <strong>Endpoint identifier<\/strong> and <strong>Source engine<\/strong> are automatically filled with its values.<\/li>\n<li>For\u00a0<strong>Access to endpoint database<\/strong>, choose to <strong>Provide access information manually.<\/strong><\/li>\n<li>Enter only the P<strong>assword<\/strong> for the database. All other things are automatically filled.<\/li>\n<li><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/44.webp\" alt=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Source Endpoint Configuration\" width=\"648\" height=\"732\" class=\"aligncenter wp-image-2487\" title=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Source Endpoint Configuration\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/44.webp 667w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/44-266x300.webp 266w\" sizes=\"(max-width: 648px) 100vw, 648px\" \/>Scroll down to the bottom and expand the <strong>Test Endpoint connection.<\/strong><\/li>\n<li>choose the same VPC that you using in this demo and choose the\u00a0<strong>Replication instance<\/strong> that you created in the previous step.<\/li>\n<li>Click the\u00a0<strong>Run test<\/strong> button to check the connection with the database.<\/li>\n<li>If the <strong>Status<\/strong> is showing\u00a0<strong>successful <\/strong>like the below picture, Click the <strong>Create endpoint <\/strong>button.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/45.webp\" alt=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Source Endpoint Test Connection\" width=\"636\" height=\"481\" class=\"aligncenter wp-image-2488\" title=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Source Endpoint Test Connection\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/45.webp 1035w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/45-300x227.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/45-1024x774.webp 1024w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/45-768x580.webp 768w\" sizes=\"(max-width: 636px) 100vw, 636px\" \/><\/p>\n<p>Endpoint for the source database is now <strong>Active.<\/strong><\/p>\n<p>Now click\u00a0<strong>Create endpoint <\/strong>to create the <strong>target endpoint<\/strong> for the target database.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/46.webp\" alt=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Source Endpoint Created\" width=\"1513\" height=\"342\" class=\"aligncenter wp-image-2489 size-full\" title=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Source Endpoint Created\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/46.webp 1513w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/46-300x68.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/46-1024x231.webp 1024w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/46-768x174.webp 768w\" sizes=\"(max-width: 1513px) 100vw, 1513px\" \/><\/p>\n<p>For <strong>endpoint type<\/strong> choose <strong>Target endpoint<\/strong> and check <strong>right<\/strong> for <strong>Select RDS DB instance.<\/strong><\/p>\n<p>For RDS Instance, choose the <strong>target DB cluster<\/strong> with the <strong>latest PostgreSQL version<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/47.webp\" alt=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Choose Target Endpoint\" width=\"822\" height=\"403\" class=\"aligncenter wp-image-2490\" title=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Choose Target Endpoint\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/47.webp 1010w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/47-300x147.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/47-768x376.webp 768w\" sizes=\"(max-width: 822px) 100vw, 822px\" \/><\/p>\n<ul>\n<li>Under the\u00a0<strong>Endpoint configuration,\u00a0<\/strong>for <strong>Endpoint identifier<\/strong> and <strong>target engine<\/strong> are automatically filled with its values.<\/li>\n<li>For\u00a0<strong>Access to endpoint database<\/strong>, choose to <strong>Provide access information manually.<\/strong><\/li>\n<li>Enter only the P<strong>assword<\/strong> for the database. All other things are automatically filled.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/48.webp\" alt=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Target Endpoint Configuration\" width=\"667\" height=\"756\" class=\"aligncenter wp-image-2491 size-full\" title=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Target Endpoint Configuration\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/48.webp 667w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/48-265x300.webp 265w\" sizes=\"(max-width: 667px) 100vw, 667px\" \/><\/p>\n<ul>\n<li>Scroll down to the bottom and expand the <strong>Test Endpoint connection.<\/strong><\/li>\n<li>choose <strong>VPC<\/strong> and <strong>Replication instance.<\/strong><\/li>\n<li>Click <strong>Run test <\/strong>and if the connection was\u00a0<strong>successful<\/strong>, Click the <strong>Create endpoint <\/strong>button.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/49.webp\" alt=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Target Endpoint Test Connection\" width=\"719\" height=\"520\" class=\"aligncenter wp-image-2492\" title=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Target Endpoint Test Connection\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/49.webp 1108w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/49-300x217.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/49-1024x741.webp 1024w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/49-768x556.webp 768w\" sizes=\"(max-width: 719px) 100vw, 719px\" \/><\/p>\n<p>All two endpoints are created successfully and in <strong>Active status.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/50.webp\" alt=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Created Source and Target Endpoints\" width=\"1512\" height=\"405\" class=\"aligncenter wp-image-2493 size-full\" title=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Created Source and Target Endpoints\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/50.webp 1512w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/50-300x80.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/50-1024x274.webp 1024w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/50-768x206.webp 768w\" sizes=\"(max-width: 1512px) 100vw, 1512px\" \/><\/p>\n<h3><span id=\"Create_Database_Migration_Task\">Create Database Migration Task<\/span><\/h3>\n<p>Now it&#8217;s time to create a Database migration task.<\/p>\n<p>Navigate to the <strong>Database migration tasks<\/strong> section and click <strong>Create database migration task.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/51.webp\" alt=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Creating Database Migration Task\" width=\"1861\" height=\"605\" class=\"aligncenter wp-image-2494 size-full\" title=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Creating Database Migration Task\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/51.webp 1861w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/51-300x98.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/51-1024x333.webp 1024w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/51-768x250.webp 768w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/51-1536x499.webp 1536w\" sizes=\"(max-width: 1861px) 100vw, 1861px\" \/><\/p>\n<ul>\n<li><span>For\u00a0<strong>Task identifier<\/strong>, provide a name for the task.<\/span><\/li>\n<li><span>Choose the\u00a0<strong>replication instance<\/strong>\u00a0which we created for the Replication instance.<\/span><\/li>\n<li><span>For the <strong>Source database endpoint<\/strong>, choose the endpoint you have created for the <strong>source<\/strong> and for the\u00a0<strong>Target database endpoint<\/strong>, choose the endpoint you\u2019ve created for the <strong>target.<\/strong><\/span><\/li>\n<li><span>For the\u00a0<strong>Migration type,<\/strong>\u00a0choose\u00a0<strong>Migrate existing data and replicate ongoing changes<\/strong>.<\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/52.webp\" alt=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Database Migration Task Configuration\" width=\"860\" height=\"816\" class=\"aligncenter wp-image-2495 size-full\" title=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Database Migration Task Configuration\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/52.webp 860w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/52-300x285.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/52-768x729.webp 768w\" sizes=\"(max-width: 860px) 100vw, 860px\" \/><\/p>\n<p><span>Scroll down and under the\u00a0<strong>Task settings<\/strong>, for the\u00a0<strong>Editing mode<\/strong>\u00a0choose\u00a0<strong>Wizard.<\/strong><\/span><\/p>\n<p><span>Change the following and keep the default values to the remaining options:<\/span><\/p>\n<ol>\n<li><strong>Target table operation mode \u2013 Truncate<\/strong><\/li>\n<li><strong>Turn on validation \u2013 Enable<\/strong><\/li>\n<li><strong>Turn on Cloudwatch Logs \u2013 Enable<\/strong><\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/53.webp\" alt=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Database Migration Task Settings\" width=\"753\" height=\"870\" class=\"aligncenter wp-image-2496 \" title=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Database Migration Task Settings\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/53.webp 707w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/53-260x300.webp 260w\" sizes=\"(max-width: 753px) 100vw, 753px\" \/><\/p>\n<ul>\n<li><span>Scroll down under the <strong>Table mappings<\/strong> and choose <strong>Wizard<\/strong> for <strong>Editing<\/strong>\u00a0<strong>mode.<\/strong><\/span><\/li>\n<li><span>Expand <strong>Selection rules<\/strong>\u00a0and Click\u00a0<strong>Add<\/strong>\u00a0<strong>new selection rule<\/strong>.<\/span><\/li>\n<li><span>For\u00a0<strong>Schema<\/strong>\u00a0select\u00a0<strong>Enter a schema<\/strong>.<\/span><\/li>\n<li>Leave all other things as default. So all tables inside the source database will be migrated to the target database.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/54.webp\" alt=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Database Migration Table Mappings\" width=\"852\" height=\"802\" class=\"aligncenter wp-image-2497 size-full\" title=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Database Migration Table Mappings\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/54.webp 852w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/54-300x282.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/54-768x723.webp 768w\" sizes=\"(max-width: 852px) 100vw, 852px\" \/><\/p>\n<p>Scroll down to the bottom and click <strong>Create task<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/55.webp\" alt=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Database Migration Create Task\" width=\"873\" height=\"527\" class=\"aligncenter wp-image-2498 size-full\" title=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Database Migration Create Task\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/55.webp 873w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/55-300x181.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/55-768x464.webp 768w\" sizes=\"(max-width: 873px) 100vw, 873px\" \/><\/p>\n<p>The migration task gets created. Wait until it shows <strong>Running.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/56.webp\" alt=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Database Migration Task Creating\" width=\"1595\" height=\"322\" class=\"aligncenter wp-image-2499 size-full\" title=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Database Migration Task Creating\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/56.webp 1595w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/56-300x61.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/56-1024x207.webp 1024w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/56-768x155.webp 768w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/56-1536x310.webp 1536w\" sizes=\"(max-width: 1595px) 100vw, 1595px\" \/><\/p>\n<p>Once the creation is completed, you can able to see the <strong>Status\u00a0<\/strong>of the task with\u00a0<strong>Load compile, replication ongoing<\/strong>.<\/p>\n<p>Click the <strong>Table statistics,\u00a0<\/strong>you can see the\u00a0<strong>Load state\u00a0<\/strong>is like the <strong>Table completed<\/strong>.<\/p>\n<p>So the Database migration process is successfully done.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/57.webp\" alt=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Database Migration Task Table Statistics\" width=\"1466\" height=\"712\" class=\"aligncenter wp-image-2500 size-full\" title=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Database Migration Task Table Statistics\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/57.webp 1466w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/57-300x146.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/57-1024x497.webp 1024w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/57-768x373.webp 768w\" sizes=\"(max-width: 1466px) 100vw, 1466px\" \/><\/p>\n<p>To check, the migration, log in to the target database and run the following command to see if the contents are migrated to this database from the source.<\/p>\n<pre>\\d\r\nselect * from COMPANY;<\/pre>\n<p>You can see the table is created and the contents are also stored in the target database.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/58.webp\" alt=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Check Migration in Target DB\" width=\"1682\" height=\"510\" class=\"aligncenter wp-image-2501 size-full\" title=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Check Migration in Target DB\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/58.webp 1682w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/58-300x91.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/58-1024x310.webp 1024w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/58-768x233.webp 768w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/58-1536x466.webp 1536w\" sizes=\"(max-width: 1682px) 100vw, 1682px\" \/><\/p>\n<h3><span id=\"Check_the_Replication\">Check the Replication<\/span><\/h3>\n<h3><span id=\"In_Primary_Database\">In Source Database<\/span><\/h3>\n<p>First login to the source database and run the following command to add some new rows to the <strong>company<\/strong> table.<\/p>\n<pre>INSERT INTO COMPANY VALUES (2, 'Arun', 28, 'New York', 20000.00), (3, 'Abishek', 36, 'Chicago', 42000.00), (4, 'Sarath', 26, 'Los Angeles', 25000.00), (5, 'Xavier', 42, 'San Francisco', 39000.00);<\/pre>\n<p>Run the below command to see the add rows inside the table.<\/p>\n<pre>select * from COMPANY;\r\nexit;<\/pre>\n<p>As you can see the table contains a total of 5 rows. Now check whether it will be replicated in the target database or not.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/59.webp\" alt=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Adding Rows Inside Source Database\" width=\"1682\" height=\"460\" class=\"aligncenter wp-image-2502 size-full\" title=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Adding Rows Inside Source Database\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/59.webp 1682w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/59-300x82.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/59-1024x280.webp 1024w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/59-768x210.webp 768w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/59-1536x420.webp 1536w\" sizes=\"(max-width: 1682px) 100vw, 1682px\" \/><\/p>\n<h3><span id=\"In_Primary_Database\">In Target Database<\/span><\/h3>\n<p>Login into the target database and run the below command to see the replication.<\/p>\n<pre>select * from COMPANY;\r\nexit;<\/pre>\n<p>You can see that now the table in the target database also has 5 rows.<\/p>\n<p>So all the contents that will add or remove from the source database will also replicate in the target database also.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/60.webp\" alt=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Check Replication in Target Database\" width=\"1678\" height=\"406\" class=\"aligncenter wp-image-2504 size-full\" title=\"Upgrade Aurora PostgreSQL latest version with 0 Downtime using DMS Check Replication in Target Database\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/60.webp 1678w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/60-300x73.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/60-1024x248.webp 1024w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/60-768x186.webp 768w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/60-1536x372.webp 1536w\" sizes=\"(max-width: 1678px) 100vw, 1678px\" \/><\/p>\n<h2>Final Step<\/h2>\n<p><span>To this point whenever changes or updates are made from the old version source database is parallelly replicated to the secondary database which is the latest <strong>PostgreSQL<\/strong> version. But we need to set up the latest <strong>PostgreSQL<\/strong> version database as the primary one. For this just<strong> point to the upgraded database as the primary database inside the application code<\/strong>. Now the application will use the database which was upgraded to the latest version. Then delete the old Aurora PostgreSQL version database.\u00a0<\/span><\/p>\n<p><span>We are successfully upgrading the RDS Aurora PostgreSQL database to the latest PostgreSQL version with nearly zero downtime. During this process, there will no downtime in your application.<\/span><\/p>\n<p>That&#8217;s all I want to show you. See you in the next article. Thank you.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In our previous blog, we could see how to upgrade the RDS MySQL version to the latest version with zero downtime using AWS DMS. In this blog, we are going to discuss upgrading the Amazon Aurora PostgreSQL version from 10.21 to the latest version(for now 14.5) using DMS. We just follow the same but little [&hellip;]<\/p>\n","protected":false},"author":20,"featured_media":2569,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[2,128],"tags":[437,438],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.7 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to Upgrade Amazon Aurora PostgreSQL using AWS DMS<\/title>\n<meta name=\"description\" content=\"Learn how to upgrade your Amazon Aurora PostgreSQL database using AWS Database Migration Service (DMS). Explore Now!\" \/>\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.easydeploy.io\/blog\/upgrade-amazon-aurora-postgresql-latest-version\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Upgrade Amazon Aurora PostgreSQL using AWS DMS\" \/>\n<meta property=\"og:description\" content=\"Learn how to upgrade your Amazon Aurora PostgreSQL database using AWS Database Migration Service (DMS). Explore Now!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.easydeploy.io\/blog\/upgrade-amazon-aurora-postgresql-latest-version\/\" \/>\n<meta property=\"og:site_name\" content=\"easydeploy.io\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/Jerinrathnam\" \/>\n<meta property=\"article:published_time\" content=\"2023-01-12T12:06:38+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-03-29T12:01:31+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/How-upgrade-Amazon-Aurora-PostgreSQL-Latest-version-with-zero-to-minimal-downtime-using-A.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"1280\" \/>\n\t<meta property=\"og:image:height\" content=\"720\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/webp\" \/>\n<meta name=\"author\" content=\"Jerin Rathnam\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@jerin_rathnam\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jerin Rathnam\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"21 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.easydeploy.io\/blog\/upgrade-amazon-aurora-postgresql-latest-version\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.easydeploy.io\/blog\/upgrade-amazon-aurora-postgresql-latest-version\/\"},\"author\":{\"name\":\"Jerin Rathnam\",\"@id\":\"https:\/\/www.easydeploy.io\/blog\/#\/schema\/person\/939543ac3b33fadea8b5115ab9a1280f\"},\"headline\":\"How upgrade Amazon Aurora PostgreSQL latest version with zero to minimal downtime using AWS DMS\",\"datePublished\":\"2023-01-12T12:06:38+00:00\",\"dateModified\":\"2023-03-29T12:01:31+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.easydeploy.io\/blog\/upgrade-amazon-aurora-postgresql-latest-version\/\"},\"wordCount\":2178,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.easydeploy.io\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.easydeploy.io\/blog\/upgrade-amazon-aurora-postgresql-latest-version\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/How-upgrade-Amazon-Aurora-PostgreSQL-Latest-version-with-zero-to-minimal-downtime-using-A.webp\",\"keywords\":[\"Amazon Aurora PostgreSQL\",\"AWS DMS\"],\"articleSection\":[\"Amazon Web Services\",\"Cloud Computing\"],\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.easydeploy.io\/blog\/upgrade-amazon-aurora-postgresql-latest-version\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.easydeploy.io\/blog\/upgrade-amazon-aurora-postgresql-latest-version\/\",\"url\":\"https:\/\/www.easydeploy.io\/blog\/upgrade-amazon-aurora-postgresql-latest-version\/\",\"name\":\"How to Upgrade Amazon Aurora PostgreSQL using AWS DMS\",\"isPartOf\":{\"@id\":\"https:\/\/www.easydeploy.io\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.easydeploy.io\/blog\/upgrade-amazon-aurora-postgresql-latest-version\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.easydeploy.io\/blog\/upgrade-amazon-aurora-postgresql-latest-version\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/How-upgrade-Amazon-Aurora-PostgreSQL-Latest-version-with-zero-to-minimal-downtime-using-A.webp\",\"datePublished\":\"2023-01-12T12:06:38+00:00\",\"dateModified\":\"2023-03-29T12:01:31+00:00\",\"description\":\"Learn how to upgrade your Amazon Aurora PostgreSQL database using AWS Database Migration Service (DMS). Explore Now!\",\"breadcrumb\":{\"@id\":\"https:\/\/www.easydeploy.io\/blog\/upgrade-amazon-aurora-postgresql-latest-version\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.easydeploy.io\/blog\/upgrade-amazon-aurora-postgresql-latest-version\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.easydeploy.io\/blog\/upgrade-amazon-aurora-postgresql-latest-version\/#primaryimage\",\"url\":\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/How-upgrade-Amazon-Aurora-PostgreSQL-Latest-version-with-zero-to-minimal-downtime-using-A.webp\",\"contentUrl\":\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/How-upgrade-Amazon-Aurora-PostgreSQL-Latest-version-with-zero-to-minimal-downtime-using-A.webp\",\"width\":1280,\"height\":720,\"caption\":\"Amazon Aurora PostgreSQL\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.easydeploy.io\/blog\/upgrade-amazon-aurora-postgresql-latest-version\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.easydeploy.io\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How upgrade Amazon Aurora PostgreSQL latest version with zero to minimal downtime using AWS DMS\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.easydeploy.io\/blog\/#website\",\"url\":\"https:\/\/www.easydeploy.io\/blog\/\",\"name\":\"easydeploy.io\",\"description\":\"A Cloud Architect Company\",\"publisher\":{\"@id\":\"https:\/\/www.easydeploy.io\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.easydeploy.io\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.easydeploy.io\/blog\/#organization\",\"name\":\"EasyDeploy Technologies Pvt Ltd\",\"url\":\"https:\/\/www.easydeploy.io\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.easydeploy.io\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2019\/02\/easydeploy.png\",\"contentUrl\":\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2019\/02\/easydeploy.png\",\"width\":536,\"height\":100,\"caption\":\"EasyDeploy Technologies Pvt Ltd\"},\"image\":{\"@id\":\"https:\/\/www.easydeploy.io\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.easydeploy.io\/blog\/#\/schema\/person\/939543ac3b33fadea8b5115ab9a1280f\",\"name\":\"Jerin Rathnam\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.easydeploy.io\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ca2c2ab4a28d380073334816b42aaa40?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ca2c2ab4a28d380073334816b42aaa40?s=96&d=mm&r=g\",\"caption\":\"Jerin Rathnam\"},\"description\":\"Jerin Rathnam is a proficient DevOps engineer who is dedicated to streamlining software development and deployment processes. He has extensive knowledge of cloud infrastructure, containerization, and CI\/CD pipelines, which enables him to effectively connect development and operations. Jerin specializes in creating numerous Terraform modules for multi-cloud infrastructure and possesses immense expertise in configuring and managing cloud infrastructure. His profound understanding of containerization, along with his experience in orchestration tools like Docker and Kubernetes, further supports his skills as a valuable DevOps engineer.\",\"sameAs\":[\"https:\/\/www.gemjerin.site\",\"https:\/\/www.facebook.com\/Jerinrathnam\",\"https:\/\/www.instagram.com\/gem_jerin_rathnam\/\",\"https:\/\/www.linkedin.com\/in\/jerin-rathnam\/\",\"https:\/\/x.com\/jerin_rathnam\",\"@jerinrathnam\"],\"url\":\"https:\/\/www.easydeploy.io\/blog\/author\/jerin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Upgrade Amazon Aurora PostgreSQL using AWS DMS","description":"Learn how to upgrade your Amazon Aurora PostgreSQL database using AWS Database Migration Service (DMS). Explore Now!","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.easydeploy.io\/blog\/upgrade-amazon-aurora-postgresql-latest-version\/","og_locale":"en_GB","og_type":"article","og_title":"How to Upgrade Amazon Aurora PostgreSQL using AWS DMS","og_description":"Learn how to upgrade your Amazon Aurora PostgreSQL database using AWS Database Migration Service (DMS). Explore Now!","og_url":"https:\/\/www.easydeploy.io\/blog\/upgrade-amazon-aurora-postgresql-latest-version\/","og_site_name":"easydeploy.io","article_author":"https:\/\/www.facebook.com\/Jerinrathnam","article_published_time":"2023-01-12T12:06:38+00:00","article_modified_time":"2023-03-29T12:01:31+00:00","og_image":[{"width":1280,"height":720,"url":"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/How-upgrade-Amazon-Aurora-PostgreSQL-Latest-version-with-zero-to-minimal-downtime-using-A.webp","type":"image\/webp"}],"author":"Jerin Rathnam","twitter_card":"summary_large_image","twitter_creator":"@jerin_rathnam","twitter_misc":{"Written by":"Jerin Rathnam","Estimated reading time":"21 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.easydeploy.io\/blog\/upgrade-amazon-aurora-postgresql-latest-version\/#article","isPartOf":{"@id":"https:\/\/www.easydeploy.io\/blog\/upgrade-amazon-aurora-postgresql-latest-version\/"},"author":{"name":"Jerin Rathnam","@id":"https:\/\/www.easydeploy.io\/blog\/#\/schema\/person\/939543ac3b33fadea8b5115ab9a1280f"},"headline":"How upgrade Amazon Aurora PostgreSQL latest version with zero to minimal downtime using AWS DMS","datePublished":"2023-01-12T12:06:38+00:00","dateModified":"2023-03-29T12:01:31+00:00","mainEntityOfPage":{"@id":"https:\/\/www.easydeploy.io\/blog\/upgrade-amazon-aurora-postgresql-latest-version\/"},"wordCount":2178,"commentCount":0,"publisher":{"@id":"https:\/\/www.easydeploy.io\/blog\/#organization"},"image":{"@id":"https:\/\/www.easydeploy.io\/blog\/upgrade-amazon-aurora-postgresql-latest-version\/#primaryimage"},"thumbnailUrl":"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/How-upgrade-Amazon-Aurora-PostgreSQL-Latest-version-with-zero-to-minimal-downtime-using-A.webp","keywords":["Amazon Aurora PostgreSQL","AWS DMS"],"articleSection":["Amazon Web Services","Cloud Computing"],"inLanguage":"en-GB","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.easydeploy.io\/blog\/upgrade-amazon-aurora-postgresql-latest-version\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.easydeploy.io\/blog\/upgrade-amazon-aurora-postgresql-latest-version\/","url":"https:\/\/www.easydeploy.io\/blog\/upgrade-amazon-aurora-postgresql-latest-version\/","name":"How to Upgrade Amazon Aurora PostgreSQL using AWS DMS","isPartOf":{"@id":"https:\/\/www.easydeploy.io\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.easydeploy.io\/blog\/upgrade-amazon-aurora-postgresql-latest-version\/#primaryimage"},"image":{"@id":"https:\/\/www.easydeploy.io\/blog\/upgrade-amazon-aurora-postgresql-latest-version\/#primaryimage"},"thumbnailUrl":"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/How-upgrade-Amazon-Aurora-PostgreSQL-Latest-version-with-zero-to-minimal-downtime-using-A.webp","datePublished":"2023-01-12T12:06:38+00:00","dateModified":"2023-03-29T12:01:31+00:00","description":"Learn how to upgrade your Amazon Aurora PostgreSQL database using AWS Database Migration Service (DMS). Explore Now!","breadcrumb":{"@id":"https:\/\/www.easydeploy.io\/blog\/upgrade-amazon-aurora-postgresql-latest-version\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.easydeploy.io\/blog\/upgrade-amazon-aurora-postgresql-latest-version\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.easydeploy.io\/blog\/upgrade-amazon-aurora-postgresql-latest-version\/#primaryimage","url":"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/How-upgrade-Amazon-Aurora-PostgreSQL-Latest-version-with-zero-to-minimal-downtime-using-A.webp","contentUrl":"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2023\/01\/How-upgrade-Amazon-Aurora-PostgreSQL-Latest-version-with-zero-to-minimal-downtime-using-A.webp","width":1280,"height":720,"caption":"Amazon Aurora PostgreSQL"},{"@type":"BreadcrumbList","@id":"https:\/\/www.easydeploy.io\/blog\/upgrade-amazon-aurora-postgresql-latest-version\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.easydeploy.io\/blog\/"},{"@type":"ListItem","position":2,"name":"How upgrade Amazon Aurora PostgreSQL latest version with zero to minimal downtime using AWS DMS"}]},{"@type":"WebSite","@id":"https:\/\/www.easydeploy.io\/blog\/#website","url":"https:\/\/www.easydeploy.io\/blog\/","name":"easydeploy.io","description":"A Cloud Architect Company","publisher":{"@id":"https:\/\/www.easydeploy.io\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.easydeploy.io\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/www.easydeploy.io\/blog\/#organization","name":"EasyDeploy Technologies Pvt Ltd","url":"https:\/\/www.easydeploy.io\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.easydeploy.io\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2019\/02\/easydeploy.png","contentUrl":"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2019\/02\/easydeploy.png","width":536,"height":100,"caption":"EasyDeploy Technologies Pvt Ltd"},"image":{"@id":"https:\/\/www.easydeploy.io\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.easydeploy.io\/blog\/#\/schema\/person\/939543ac3b33fadea8b5115ab9a1280f","name":"Jerin Rathnam","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.easydeploy.io\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ca2c2ab4a28d380073334816b42aaa40?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ca2c2ab4a28d380073334816b42aaa40?s=96&d=mm&r=g","caption":"Jerin Rathnam"},"description":"Jerin Rathnam is a proficient DevOps engineer who is dedicated to streamlining software development and deployment processes. He has extensive knowledge of cloud infrastructure, containerization, and CI\/CD pipelines, which enables him to effectively connect development and operations. Jerin specializes in creating numerous Terraform modules for multi-cloud infrastructure and possesses immense expertise in configuring and managing cloud infrastructure. His profound understanding of containerization, along with his experience in orchestration tools like Docker and Kubernetes, further supports his skills as a valuable DevOps engineer.","sameAs":["https:\/\/www.gemjerin.site","https:\/\/www.facebook.com\/Jerinrathnam","https:\/\/www.instagram.com\/gem_jerin_rathnam\/","https:\/\/www.linkedin.com\/in\/jerin-rathnam\/","https:\/\/x.com\/jerin_rathnam","@jerinrathnam"],"url":"https:\/\/www.easydeploy.io\/blog\/author\/jerin\/"}]}},"_links":{"self":[{"href":"https:\/\/www.easydeploy.io\/blog\/wp-json\/wp\/v2\/posts\/2507"}],"collection":[{"href":"https:\/\/www.easydeploy.io\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.easydeploy.io\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.easydeploy.io\/blog\/wp-json\/wp\/v2\/users\/20"}],"replies":[{"embeddable":true,"href":"https:\/\/www.easydeploy.io\/blog\/wp-json\/wp\/v2\/comments?post=2507"}],"version-history":[{"count":11,"href":"https:\/\/www.easydeploy.io\/blog\/wp-json\/wp\/v2\/posts\/2507\/revisions"}],"predecessor-version":[{"id":2673,"href":"https:\/\/www.easydeploy.io\/blog\/wp-json\/wp\/v2\/posts\/2507\/revisions\/2673"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.easydeploy.io\/blog\/wp-json\/wp\/v2\/media\/2569"}],"wp:attachment":[{"href":"https:\/\/www.easydeploy.io\/blog\/wp-json\/wp\/v2\/media?parent=2507"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.easydeploy.io\/blog\/wp-json\/wp\/v2\/categories?post=2507"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.easydeploy.io\/blog\/wp-json\/wp\/v2\/tags?post=2507"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}