{"id":670,"date":"2023-12-01T11:52:47","date_gmt":"2023-12-01T11:52:47","guid":{"rendered":"https:\/\/unicloud.co\/blog\/?p=670"},"modified":"2023-12-11T06:17:14","modified_gmt":"2023-12-11T06:17:14","slug":"postgresql-migration","status":"publish","type":"post","link":"https:\/\/unicloud.co\/blog\/postgresql-migration\/","title":{"rendered":"Migration of PostgreSQL Database from EC2 to AWS RDS Aurora"},"content":{"rendered":"<p><img decoding=\"async\" class=\"size-full wp-image-668 aligncenter\" src=\"https:\/\/unicloud.co\/blog\/wp-content\/uploads\/2023\/12\/image-1.png\" alt=\"\" width=\"277\" height=\"125\" \/><\/p>\n<p style=\"text-align: left;\">Zee Media network is one network that began early, grew steadily, adapted along, sustained all weathers and today stands as one of India\u2019s largest, widest and most diverse-platform news network. Zee Media Corporation Limited has interests in Global, National and Regional news channels and Digital news publishing. The Company operates 14 News channels across various genre and languages. The Company also operates 32 digital properties and 7 mobile applications. The digital publishing business of the Company has been consolidated under a subsidiary company Indiadotcom Digital Private Limited\u2019 (IDPL). Zee News, the flagship channel of the network is a household name among India\u2019s news channels and among the flagbearers of free, fearless and foremost journalism.<\/p>\n<p><em>&#8220;Unicloud helps us in migrating our PostgreSQL Database from EC2 to AWS RDS Aurora which help us in delivering, a high-performance, fully managed relational database service. The mission-critical workloads leverage AWS security measures &amp; features and controls provided by RDS Aurora. This enhances the safety of our data but also streamlines database administration, making our operations more resilient and scalable. Aside from better performance and scalability, Aurora Postgres is also more reliable than many other database options. High availability is guaranteed with data replicated automatically across 3 AWS availability zones. It also offers fault tolerant and self-healing storage, instance monitoring and recovery of the database in the event of failure. One of Aurora\u2019s biggest business advantages is the significantly lower costs when compared to traditional databases. Hassle-free Storage Provisioning, it scales in and scales out based on your actual usage, so you can focus your attention on other important parts of database management. Reduce our DBAs\u2019 Stress Levels as AWS handles many routine tasks.&#8221;<\/em><\/p>\n<p><strong>Vijayant Kumar, Chief Technology Officer (CTO)<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Zee Media network is one network that began early, grew steadily, adapted along, sustained all weathers and today stands as one of India\u2019s largest, widest and most diverse-platform news network. Zee Media Corporation Limited has interests in Global, National and Regional news channels and Digital news publishing. The Company operates 14 News channels across various [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":668,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"_uag_custom_page_level_css":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"set","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"two_page_speed":[],"footnotes":""},"categories":[9],"tags":[],"class_list":["post-670","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-cloud"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.0 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Migration of PostgreSQL Database from EC2 to AWS RDS Aurora - Unicloud<\/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:\/\/unicloud.co\/blog\/postgresql-migration\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Migration of PostgreSQL Database from EC2 to AWS RDS Aurora - Unicloud\" \/>\n<meta property=\"og:description\" content=\"Zee Media network is one network that began early, grew steadily, adapted along, sustained all weathers and today stands as one of India\u2019s largest, widest and most diverse-platform news network. Zee Media Corporation Limited has interests in Global, National and Regional news channels and Digital news publishing. The Company operates 14 News channels across various [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/unicloud.co\/blog\/postgresql-migration\/\" \/>\n<meta property=\"og:site_name\" content=\"Unicloud\" \/>\n<meta property=\"article:published_time\" content=\"2023-12-01T11:52:47+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-11T06:17:14+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/unicloud.co\/blog\/wp-content\/uploads\/2023\/12\/image-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"277\" \/>\n\t<meta property=\"og:image:height\" content=\"125\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Developer\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Developer\" \/>\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:\/\/unicloud.co\/blog\/postgresql-migration\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/unicloud.co\/blog\/postgresql-migration\/\"},\"author\":{\"name\":\"Developer\",\"@id\":\"https:\/\/unicloud.co\/blog\/#\/schema\/person\/53ab139edac2be8f8c3fb4306f0ba970\"},\"headline\":\"Migration of PostgreSQL Database from EC2 to AWS RDS Aurora\",\"datePublished\":\"2023-12-01T11:52:47+00:00\",\"dateModified\":\"2023-12-11T06:17:14+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/unicloud.co\/blog\/postgresql-migration\/\"},\"wordCount\":293,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/unicloud.co\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/unicloud.co\/blog\/postgresql-migration\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/unicloud.co\/blog\/wp-content\/uploads\/2023\/12\/image-1.png\",\"articleSection\":[\"Cloud\"],\"inLanguage\":\"en\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/unicloud.co\/blog\/postgresql-migration\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/unicloud.co\/blog\/postgresql-migration\/\",\"url\":\"https:\/\/unicloud.co\/blog\/postgresql-migration\/\",\"name\":\"Migration of PostgreSQL Database from EC2 to AWS RDS Aurora - Unicloud\",\"isPartOf\":{\"@id\":\"https:\/\/unicloud.co\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/unicloud.co\/blog\/postgresql-migration\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/unicloud.co\/blog\/postgresql-migration\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/unicloud.co\/blog\/wp-content\/uploads\/2023\/12\/image-1.png\",\"datePublished\":\"2023-12-01T11:52:47+00:00\",\"dateModified\":\"2023-12-11T06:17:14+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/unicloud.co\/blog\/postgresql-migration\/#breadcrumb\"},\"inLanguage\":\"en\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/unicloud.co\/blog\/postgresql-migration\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en\",\"@id\":\"https:\/\/unicloud.co\/blog\/postgresql-migration\/#primaryimage\",\"url\":\"https:\/\/unicloud.co\/blog\/wp-content\/uploads\/2023\/12\/image-1.png\",\"contentUrl\":\"https:\/\/unicloud.co\/blog\/wp-content\/uploads\/2023\/12\/image-1.png\",\"width\":277,\"height\":125},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/unicloud.co\/blog\/postgresql-migration\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/unicloud.co\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Migration of PostgreSQL Database from EC2 to AWS RDS Aurora\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/unicloud.co\/blog\/#website\",\"url\":\"https:\/\/unicloud.co\/blog\/\",\"name\":\"Unicloud\",\"description\":\"Unicloud\",\"publisher\":{\"@id\":\"https:\/\/unicloud.co\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/unicloud.co\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/unicloud.co\/blog\/#organization\",\"name\":\"Unicloud\",\"url\":\"https:\/\/unicloud.co\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en\",\"@id\":\"https:\/\/unicloud.co\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/unicloud.co\/blog\/wp-content\/uploads\/2023\/10\/logo.jpeg\",\"contentUrl\":\"https:\/\/unicloud.co\/blog\/wp-content\/uploads\/2023\/10\/logo.jpeg\",\"width\":1024,\"height\":289,\"caption\":\"Unicloud\"},\"image\":{\"@id\":\"https:\/\/unicloud.co\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/unicloud.co\/blog\/#\/schema\/person\/53ab139edac2be8f8c3fb4306f0ba970\",\"name\":\"Developer\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en\",\"@id\":\"https:\/\/unicloud.co\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/302ebf99561fa3cf04f36c75d20f40925f0bc917b1c1e7b9e2a889a35f9e515f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/302ebf99561fa3cf04f36c75d20f40925f0bc917b1c1e7b9e2a889a35f9e515f?s=96&d=mm&r=g\",\"caption\":\"Developer\"},\"url\":\"https:\/\/unicloud.co\/blog\/author\/developer\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Migration of PostgreSQL Database from EC2 to AWS RDS Aurora - Unicloud","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:\/\/unicloud.co\/blog\/postgresql-migration\/","og_locale":"en_US","og_type":"article","og_title":"Migration of PostgreSQL Database from EC2 to AWS RDS Aurora - Unicloud","og_description":"Zee Media network is one network that began early, grew steadily, adapted along, sustained all weathers and today stands as one of India\u2019s largest, widest and most diverse-platform news network. Zee Media Corporation Limited has interests in Global, National and Regional news channels and Digital news publishing. The Company operates 14 News channels across various [&hellip;]","og_url":"https:\/\/unicloud.co\/blog\/postgresql-migration\/","og_site_name":"Unicloud","article_published_time":"2023-12-01T11:52:47+00:00","article_modified_time":"2023-12-11T06:17:14+00:00","og_image":[{"width":277,"height":125,"url":"https:\/\/unicloud.co\/blog\/wp-content\/uploads\/2023\/12\/image-1.png","type":"image\/png"}],"author":"Developer","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Developer","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/unicloud.co\/blog\/postgresql-migration\/#article","isPartOf":{"@id":"https:\/\/unicloud.co\/blog\/postgresql-migration\/"},"author":{"name":"Developer","@id":"https:\/\/unicloud.co\/blog\/#\/schema\/person\/53ab139edac2be8f8c3fb4306f0ba970"},"headline":"Migration of PostgreSQL Database from EC2 to AWS RDS Aurora","datePublished":"2023-12-01T11:52:47+00:00","dateModified":"2023-12-11T06:17:14+00:00","mainEntityOfPage":{"@id":"https:\/\/unicloud.co\/blog\/postgresql-migration\/"},"wordCount":293,"commentCount":0,"publisher":{"@id":"https:\/\/unicloud.co\/blog\/#organization"},"image":{"@id":"https:\/\/unicloud.co\/blog\/postgresql-migration\/#primaryimage"},"thumbnailUrl":"https:\/\/unicloud.co\/blog\/wp-content\/uploads\/2023\/12\/image-1.png","articleSection":["Cloud"],"inLanguage":"en","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/unicloud.co\/blog\/postgresql-migration\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/unicloud.co\/blog\/postgresql-migration\/","url":"https:\/\/unicloud.co\/blog\/postgresql-migration\/","name":"Migration of PostgreSQL Database from EC2 to AWS RDS Aurora - Unicloud","isPartOf":{"@id":"https:\/\/unicloud.co\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/unicloud.co\/blog\/postgresql-migration\/#primaryimage"},"image":{"@id":"https:\/\/unicloud.co\/blog\/postgresql-migration\/#primaryimage"},"thumbnailUrl":"https:\/\/unicloud.co\/blog\/wp-content\/uploads\/2023\/12\/image-1.png","datePublished":"2023-12-01T11:52:47+00:00","dateModified":"2023-12-11T06:17:14+00:00","breadcrumb":{"@id":"https:\/\/unicloud.co\/blog\/postgresql-migration\/#breadcrumb"},"inLanguage":"en","potentialAction":[{"@type":"ReadAction","target":["https:\/\/unicloud.co\/blog\/postgresql-migration\/"]}]},{"@type":"ImageObject","inLanguage":"en","@id":"https:\/\/unicloud.co\/blog\/postgresql-migration\/#primaryimage","url":"https:\/\/unicloud.co\/blog\/wp-content\/uploads\/2023\/12\/image-1.png","contentUrl":"https:\/\/unicloud.co\/blog\/wp-content\/uploads\/2023\/12\/image-1.png","width":277,"height":125},{"@type":"BreadcrumbList","@id":"https:\/\/unicloud.co\/blog\/postgresql-migration\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/unicloud.co\/blog\/"},{"@type":"ListItem","position":2,"name":"Migration of PostgreSQL Database from EC2 to AWS RDS Aurora"}]},{"@type":"WebSite","@id":"https:\/\/unicloud.co\/blog\/#website","url":"https:\/\/unicloud.co\/blog\/","name":"Unicloud","description":"Unicloud","publisher":{"@id":"https:\/\/unicloud.co\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/unicloud.co\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en"},{"@type":"Organization","@id":"https:\/\/unicloud.co\/blog\/#organization","name":"Unicloud","url":"https:\/\/unicloud.co\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en","@id":"https:\/\/unicloud.co\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/unicloud.co\/blog\/wp-content\/uploads\/2023\/10\/logo.jpeg","contentUrl":"https:\/\/unicloud.co\/blog\/wp-content\/uploads\/2023\/10\/logo.jpeg","width":1024,"height":289,"caption":"Unicloud"},"image":{"@id":"https:\/\/unicloud.co\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/unicloud.co\/blog\/#\/schema\/person\/53ab139edac2be8f8c3fb4306f0ba970","name":"Developer","image":{"@type":"ImageObject","inLanguage":"en","@id":"https:\/\/unicloud.co\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/302ebf99561fa3cf04f36c75d20f40925f0bc917b1c1e7b9e2a889a35f9e515f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/302ebf99561fa3cf04f36c75d20f40925f0bc917b1c1e7b9e2a889a35f9e515f?s=96&d=mm&r=g","caption":"Developer"},"url":"https:\/\/unicloud.co\/blog\/author\/developer\/"}]}},"uagb_featured_image_src":{"full":["https:\/\/unicloud.co\/blog\/wp-content\/uploads\/2023\/12\/image-1.png",277,125,false],"thumbnail":["https:\/\/unicloud.co\/blog\/wp-content\/uploads\/2023\/12\/image-1-150x125.png",150,125,true],"medium":["https:\/\/unicloud.co\/blog\/wp-content\/uploads\/2023\/12\/image-1.png",277,125,false],"medium_large":["https:\/\/unicloud.co\/blog\/wp-content\/uploads\/2023\/12\/image-1.png",277,125,false],"large":["https:\/\/unicloud.co\/blog\/wp-content\/uploads\/2023\/12\/image-1.png",277,125,false],"1536x1536":["https:\/\/unicloud.co\/blog\/wp-content\/uploads\/2023\/12\/image-1.png",277,125,false],"2048x2048":["https:\/\/unicloud.co\/blog\/wp-content\/uploads\/2023\/12\/image-1.png",277,125,false],"tenweb_optimizer_mobile":["https:\/\/unicloud.co\/blog\/wp-content\/uploads\/2023\/12\/image-1.png",277,125,false],"tenweb_optimizer_tablet":["https:\/\/unicloud.co\/blog\/wp-content\/uploads\/2023\/12\/image-1.png",277,125,false]},"uagb_author_info":{"display_name":"Developer","author_link":"https:\/\/unicloud.co\/blog\/author\/developer\/"},"uagb_comment_info":4,"uagb_excerpt":"Zee Media network is one network that began early, grew steadily, adapted along, sustained all weathers and today stands as one of India\u2019s largest, widest and most diverse-platform news network. Zee Media Corporation Limited has interests in Global, National and Regional news channels and Digital news publishing. The Company operates 14 News channels across various&hellip;","_links":{"self":[{"href":"https:\/\/unicloud.co\/blog\/wp-json\/wp\/v2\/posts\/670","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/unicloud.co\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/unicloud.co\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/unicloud.co\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/unicloud.co\/blog\/wp-json\/wp\/v2\/comments?post=670"}],"version-history":[{"count":7,"href":"https:\/\/unicloud.co\/blog\/wp-json\/wp\/v2\/posts\/670\/revisions"}],"predecessor-version":[{"id":702,"href":"https:\/\/unicloud.co\/blog\/wp-json\/wp\/v2\/posts\/670\/revisions\/702"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/unicloud.co\/blog\/wp-json\/wp\/v2\/media\/668"}],"wp:attachment":[{"href":"https:\/\/unicloud.co\/blog\/wp-json\/wp\/v2\/media?parent=670"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/unicloud.co\/blog\/wp-json\/wp\/v2\/categories?post=670"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/unicloud.co\/blog\/wp-json\/wp\/v2\/tags?post=670"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}