{"id":14831,"date":"2020-01-27T08:10:22","date_gmt":"2020-01-27T08:10:22","guid":{"rendered":"https:\/\/dbtut.com\/?p=14831"},"modified":"2020-01-29T06:49:55","modified_gmt":"2020-01-29T06:49:55","slug":"upgrade-postgresql-11-to-12","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2020\/01\/27\/upgrade-postgresql-11-to-12\/","title":{"rendered":"Upgrade PostgreSQL 11 to 12"},"content":{"rendered":"<p>In this article, we will upgrade PostgreSQL 11 to 12. If you want to upgrade PostgreSQL 10 to 11 you should read the article &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/10\/30\/upgrade-postgresql-10-to-11\/\" target=\"_blank\" rel=\"noopener noreferrer\">Upgrade PostgreSQL 10 to 11<\/a>&#8221;<\/p>\n<p>PostgreSQL is evolving day by day and every new release comes with different features. One of the features of PostgreSQL 12 is the optimization of read \/ write performance in the B-tree index.<\/p>\n<p>The REINDEX CONCURRENTLY property has been added and lots of new features have been announced.<\/p>\n<p>We need to complete the postgresql12 installation first for the upgrade. Install postgresql12 with packages as follows.<\/p>\n<pre class=\"lang:default decode:true \">yum install postgresql12 postgresql12-devel postgresql12-contrib postgresql12-libs postgresql12-server<\/pre>\n<p id=\"HrDORHK\"><img loading=\"lazy\" decoding=\"async\" width=\"841\" height=\"433\" class=\"size-full wp-image-14816 aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/img_5e1ebf4937b49.png\" alt=\"\" \/><\/p>\n<p>We have completed the installation. Let&#8217;s switch to the postgres user and perform the initdb operation by specifying the data and log files as follows. If not specified, default path will be set.<\/p>\n<pre class=\"lang:default decode:true\">\/usr\/pgsql-11\/bin\/initdb -D DATA_DIRECTORY -X LOG_DIRECTORY<\/pre>\n<p>We specify the path where the data files will be created with the -D parameter, and we specify the path where the log files will be created with the -X parameter.<\/p>\n<h4>Sample initdb script<\/h4>\n<pre class=\"lang:default decode:true \">\/usr\/pgsql-12\/bin\/initdb -D \/postgresql12\/data -X \/postgresql12\/log<\/pre>\n<p>We see that the initdb has performed successfully.<\/p>\n<p id=\"uwSidGz\"><img loading=\"lazy\" decoding=\"async\" width=\"751\" height=\"413\" class=\"size-full wp-image-14817 aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/img_5e1ec0d4d23c7.png\" alt=\"\" \/><\/p>\n<h2>Upgrade PostgreSQL 11 to 12<\/h2>\n<p>We have done Postgresql12 installation and initdb processes, we can stop the service and start the upgrade process.<\/p>\n<pre class=\"lang:default decode:true \">systemctl stop postgresql-11<\/pre>\n<h3>Upgrade Test<\/h3>\n<p>After we stop the service, we will do the upgrade test. While doing this, you need to fill the following commands completely.<\/p>\n<pre class=\"lang:default decode:true\">\/usr\/pgsql-12\/bin\/pg_upgrade \\ \u00a0 --old-datadir= postgresql11 data directory \\ \u00a0 --new-datadir=postgresql12 data directory \\ \u00a0 --old-bindir=postgresql11 bin file \\ \u00a0 --new-bindir=postgresql12 bin file \\ \u00a0 --old-options '-c config_file=postgresql11 postgresql.conf file' \\ \u00a0 --new-options '-c config_file=postgresql12 postgresql.conf file' \\ \u00a0 --check<\/pre>\n<p>We configure the pg_upgrade script above as follows and performing upgrade test.<\/p>\n<pre class=\"lang:default decode:true \">\/usr\/pgsql-12\/bin\/pg_upgrade \\ \u00a0 --old-datadir=\/postgresql11\/data \\ \u00a0 --new-datadir=\/postgresql12\/data \\ \u00a0 --old-bindir=\/usr\/pgsql-11\/bin \\ \u00a0 --new-bindir=\/usr\/pgsql-12\/bin \\ \u00a0 --old-options '-c config_file=\/postgresql11\/data\/postgresql.conf' \\ \u00a0 --new-options '-c config_file=\/postgresql12\/data\/postgresql.conf' \\ \u00a0 --check<\/pre>\n<p id=\"sCXEeep\"><img loading=\"lazy\" decoding=\"async\" width=\"858\" height=\"505\" class=\"size-full wp-image-14832  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/img_5e2e9089846f1.png\" alt=\"\" \/><\/p>\n<h3>Upgrade<\/h3>\n<p>As can be seen from the screenshot above, the upgrade test has been successfully completed. If you have the same result in your test, you can remove the check command in the test script and perform the upgrade.<\/p>\n<pre class=\"lang:default decode:true \">\u00a0\/usr\/pgsql-12\/bin\/pg_upgrade \\\n\n\u00a0 --old-datadir=\/postgresql11\/data \\\n\n\u00a0 --new-datadir=\/postgresql12\/data \\\n\n\u00a0 --old-bindir=\/usr\/pgsql-11\/bin \\\n\n\u00a0 --new-bindir=\/usr\/pgsql-12\/bin \\\n\n\u00a0 --old-options '-c config_file=\/postgresql11\/data\/postgresql.conf' \\\n\n\u00a0 --new-options '-c config_file=\/postgresql12\/data\/postgresql.conf' \\<\/pre>\n<p id=\"YfHykTs\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-14833  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/img_5e2e9143b386e.png\" alt=\"\" width=\"1011\" height=\"418\" \/><\/p>\n<h3>Configure Environments After Upgrade<\/h3>\n<p>Upgrade has been successfully completed. We need to enable the service, but first we need to change the value of &#8220;Environment = PGDATA&#8221; parameter in the postgresql-12 service as our own data directory.<\/p>\n<p>You need to do this with the root user.<\/p>\n<pre class=\"lang:default decode:true \">vi \/lib\/systemd\/system\/postgresql-12.service<\/pre>\n<p id=\"lsvMoFz\"><img loading=\"lazy\" decoding=\"async\" width=\"802\" height=\"761\" class=\"size-full wp-image-14834  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/img_5e2e9201c4017.png\" alt=\"\" \/><\/p>\n<p>We write the postgresql-12 data directory to Environment = PGDATA parameter and save and exit.<\/p>\n<h4>Enable PostgreSQL Service<\/h4>\n<pre class=\"lang:default decode:true \">systemctl enable postgresql-12<\/pre>\n<h4>Start PostgreSQL Service<\/h4>\n<pre class=\"lang:default decode:true \">systemctl start postgresql-12<\/pre>\n<h4>Check PostgreSQL Service Status<\/h4>\n<pre class=\"lang:default decode:true \">systemctl status postgresql-12<\/pre>\n<p id=\"yyeGqjs\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-14835  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/img_5e2e97dd13d96.png\" alt=\"\" width=\"998\" height=\"311\" \/><\/p>\n<p>As you can see, we started the service from the new data directory.<\/p>\n<p>You have seen that there is no problem in the upgrade process and you have done the necessary tests.<\/p>\n<h3>Delete Old PostgreSQL Cluster<\/h3>\n<p>Finally, if you want to delete postgresql11 directory, postgresql prepares sh script for you.<\/p>\n<pre class=\"lang:default decode:true \">delete_old_cluster.sh<\/pre>\n<p>When you run the above .sh file, everything related to postgresql11 will be deleted.<\/p>\n<p><strong>NOTE:<\/strong> I recommend that you do not run the delete_old_cluster.sh script without completing your tests.<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_14831\" class=\"pvc_stats all  \" data-element-id=\"14831\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>In this article, we will upgrade PostgreSQL 11 to 12. If you want to upgrade PostgreSQL 10 to 11 you should read the article &#8220;Upgrade PostgreSQL 10 to 11&#8221; PostgreSQL is evolving day by day and every new release comes with different features. One of the features of PostgreSQL 12 is the optimization of read &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_14831\" class=\"pvc_stats all  \" data-element-id=\"14831\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":366,"featured_media":14874,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[5],"tags":[8016,8015,2922,8014],"class_list":["post-14831","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-postgres","tag-postgresql-upgrade-11","tag-postgresql-upgrade-database","tag-upgrade-postgresql","tag-upgrade-postgresql-11-to-12"],"aioseo_notices":[],"a3_pvc":{"activated":true,"total_views":4389,"today_views":0},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Upgrade PostgreSQL 11 to 12 - Database Tutorials<\/title>\n<meta name=\"description\" content=\"Upgrade PostgreSQL 11 to 12\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2020\/01\/27\/upgrade-postgresql-11-to-12\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Upgrade PostgreSQL 11 to 12 - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"Upgrade PostgreSQL 11 to 12\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2020\/01\/27\/upgrade-postgresql-11-to-12\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2020-01-27T08:10:22+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-01-29T06:49:55+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z-22.png\" \/>\n\t<meta property=\"og:image:width\" content=\"593\" \/>\n\t<meta property=\"og:image:height\" content=\"292\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Faruk Erdem\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Faruk Erdem\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/27\/upgrade-postgresql-11-to-12\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/27\/upgrade-postgresql-11-to-12\/\"},\"author\":{\"name\":\"Faruk Erdem\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/a7dfc5684c116e536b4e93ee214ccbfb\"},\"headline\":\"Upgrade PostgreSQL 11 to 12\",\"datePublished\":\"2020-01-27T08:10:22+00:00\",\"dateModified\":\"2020-01-29T06:49:55+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/27\/upgrade-postgresql-11-to-12\/\"},\"wordCount\":412,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/27\/upgrade-postgresql-11-to-12\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z-22.png\",\"keywords\":[\"postgresql upgrade 11\",\"postgresql upgrade database\",\"Upgrade PostgreSQL\",\"Upgrade PostgreSQL 11 to 12\"],\"articleSection\":[\"PostgreSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2020\/01\/27\/upgrade-postgresql-11-to-12\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/27\/upgrade-postgresql-11-to-12\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/27\/upgrade-postgresql-11-to-12\/\",\"name\":\"Upgrade PostgreSQL 11 to 12 - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/27\/upgrade-postgresql-11-to-12\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/27\/upgrade-postgresql-11-to-12\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z-22.png\",\"datePublished\":\"2020-01-27T08:10:22+00:00\",\"dateModified\":\"2020-01-29T06:49:55+00:00\",\"description\":\"Upgrade PostgreSQL 11 to 12\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/27\/upgrade-postgresql-11-to-12\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2020\/01\/27\/upgrade-postgresql-11-to-12\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/27\/upgrade-postgresql-11-to-12\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z-22.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z-22.png\",\"width\":593,\"height\":292},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/27\/upgrade-postgresql-11-to-12\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Upgrade PostgreSQL 11 to 12\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/a7dfc5684c116e536b4e93ee214ccbfb\",\"name\":\"Faruk Erdem\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ad1e61fb5a7c9a590e765f7cad8f2dc8332090f1ceb9a5ee2aa95c69213f0c50?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ad1e61fb5a7c9a590e765f7cad8f2dc8332090f1ceb9a5ee2aa95c69213f0c50?s=96&d=mm&r=g\",\"caption\":\"Faruk Erdem\"},\"url\":\"https:\/\/dbtut.com\/index.php\/author\/farukerdem\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Upgrade PostgreSQL 11 to 12 - Database Tutorials","description":"Upgrade PostgreSQL 11 to 12","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:\/\/dbtut.com\/index.php\/2020\/01\/27\/upgrade-postgresql-11-to-12\/","og_locale":"en_US","og_type":"article","og_title":"Upgrade PostgreSQL 11 to 12 - Database Tutorials","og_description":"Upgrade PostgreSQL 11 to 12","og_url":"https:\/\/dbtut.com\/index.php\/2020\/01\/27\/upgrade-postgresql-11-to-12\/","og_site_name":"Database Tutorials","article_published_time":"2020-01-27T08:10:22+00:00","article_modified_time":"2020-01-29T06:49:55+00:00","og_image":[{"width":593,"height":292,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z-22.png","type":"image\/png"}],"author":"Faruk Erdem","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Faruk Erdem","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/27\/upgrade-postgresql-11-to-12\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/27\/upgrade-postgresql-11-to-12\/"},"author":{"name":"Faruk Erdem","@id":"https:\/\/dbtut.com\/#\/schema\/person\/a7dfc5684c116e536b4e93ee214ccbfb"},"headline":"Upgrade PostgreSQL 11 to 12","datePublished":"2020-01-27T08:10:22+00:00","dateModified":"2020-01-29T06:49:55+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/27\/upgrade-postgresql-11-to-12\/"},"wordCount":412,"commentCount":1,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/27\/upgrade-postgresql-11-to-12\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z-22.png","keywords":["postgresql upgrade 11","postgresql upgrade database","Upgrade PostgreSQL","Upgrade PostgreSQL 11 to 12"],"articleSection":["PostgreSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2020\/01\/27\/upgrade-postgresql-11-to-12\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/27\/upgrade-postgresql-11-to-12\/","url":"https:\/\/dbtut.com\/index.php\/2020\/01\/27\/upgrade-postgresql-11-to-12\/","name":"Upgrade PostgreSQL 11 to 12 - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/27\/upgrade-postgresql-11-to-12\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/27\/upgrade-postgresql-11-to-12\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z-22.png","datePublished":"2020-01-27T08:10:22+00:00","dateModified":"2020-01-29T06:49:55+00:00","description":"Upgrade PostgreSQL 11 to 12","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/27\/upgrade-postgresql-11-to-12\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2020\/01\/27\/upgrade-postgresql-11-to-12\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/27\/upgrade-postgresql-11-to-12\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z-22.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z-22.png","width":593,"height":292},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/27\/upgrade-postgresql-11-to-12\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"Upgrade PostgreSQL 11 to 12"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/a7dfc5684c116e536b4e93ee214ccbfb","name":"Faruk Erdem","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ad1e61fb5a7c9a590e765f7cad8f2dc8332090f1ceb9a5ee2aa95c69213f0c50?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ad1e61fb5a7c9a590e765f7cad8f2dc8332090f1ceb9a5ee2aa95c69213f0c50?s=96&d=mm&r=g","caption":"Faruk Erdem"},"url":"https:\/\/dbtut.com\/index.php\/author\/farukerdem\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/14831","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/366"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=14831"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/14831\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/14874"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=14831"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=14831"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=14831"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}