{"id":4137,"date":"2023-06-14T08:19:23","date_gmt":"2023-06-14T08:19:23","guid":{"rendered":"https:\/\/test.opensource-db.in\/wp1\/?p=4137"},"modified":"2023-06-14T08:33:54","modified_gmt":"2023-06-14T08:33:54","slug":"the-quick-and-easy-way-to-upgrade-postgres-using-pg_upgrade","status":"publish","type":"post","link":"https:\/\/test.opensource-db.in\/wp1\/the-quick-and-easy-way-to-upgrade-postgres-using-pg_upgrade\/","title":{"rendered":"The quick and easy way to upgrade Postgres using ‘pg_upgrade’"},"content":{"rendered":"\n

Why pg_upgrade?<\/strong><\/h2>\n\n\n\n

pg_upgrade<\/strong> is a utility provided by PostgreSQL that allows you to upgrade your database cluster from an older version to a newer version without the need for a lengthy dump and restore process. <\/p>\n\n\n\n

This utility is not required for minor version upgrades, which means that upgrading your current version of 11.1 to 11.9, this utility is not necessary.<\/p>\n\n\n\n

Performing pg_upgrade<\/strong><\/h2>\n\n\n\n

To upgrade from PostgreSQL version 11 (current version) to version 15 (a newer version) using pg_upgrade<\/strong><\/code>, follow these step-by-step instructions:<\/p>\n\n\n\n

Step 1:  <\/strong>Prerequisites <\/p>\n\n\n\n

Note:<\/em> Make sure you have created a latest backup of your PostgreSQL 11 (i.e.,current version) databases.<\/em><\/p>\n\n\n\n

Download and install PostgreSQL 15 (i.e., the newer version) on your system.<\/p>\n\n\n\n

Step 2:<\/strong> Install PostgreSQL 15 Cluster<\/p>\n\n\n\n

sudo dnf install -y https:\/\/download.postgresql.org\/pub\/repos\/yum\/reporpms\/EL-9-x86_64\/pgdg-redhat-repo-latest.noarch.rpm
sudo dnf -qy module disable postgresql
sudo dnf install -y postgresql15-ser<\/code><\/p>\n\n\n\n

Step 3:<\/strong> Initialize the new PostgreSQL-15 cluster<\/p>\n\n\n\n

sudo \/usr\/pgsql-15\/bin\/postgresql-15-setup initdb
sudo systemctl enable postgresql-15
sudo systemctl start postgresql-15<\/code><\/p>\n\n\n\n

Step 4:<\/strong> Stop both PostgreSQL Clusters<\/p>\n\n\n\n

sudo systemctl stop postgresql-15<\/code><\/p>\n\n\n\n

sudo systemctl stop postgresql-11<\/code><\/p>\n\n\n\n

Step 5:<\/strong> Perform upgrade check<\/p>\n\n\n\n

Before performing pg_upgrade<\/strong>, we have to check if the clusters are compatible or not. So we can use the option –check<\/em><\/p>\n\n\n\n

[postgres@localhost data]$ \/usr\/pgsql-15\/bin\/pg_upgrade -b \/usr\/pgsql-11\/bin\/ -B \/usr\/pgsql-15\/bin\/ -d \/var\/lib\/pgsql\/11\/data\/ -D \/var\/lib\/pgsql\/15\/data\/ -o ' -c config_file=\/var\/lib\/pgsql\/11\/data\/postgresql.conf' -O ' -c config_file=\/var\/lib\/pgsql\/15\/data\/postgresql.conf' --check<\/code><\/p>\n\n\n\n

In this step, if the “–check<\/em>” command fails, indicating an error, it is necessary to investigate and resolve the issue before proceeding. <\/p>\n\n\n\n

When repmgr<\/em> is running on a PostgreSQL cluster, the following error message may occur:<\/p>\n\n\n\n

Performing Consistency Checks on Old Live Server<\/code>
—————————————————————————–
Checking cluster versions ok<\/code>
Checking database user is the install user ok
Checking database connection settings ok
Checking for prepared transactions ok
Checking for system-defined composite types in user tables ok
Checking for reg* data types in user tables ok
Checking for contrib\/isn with bigint-passing mismatch ok
Checking for tables WITH OIDS ok
Checking for invalid \"sql_identifier\" user columns ok
Checking for presence of required libraries fatal<\/code>
Your installation references loadable libraries that are missing from the
new installation. You can add these libraries to the new installation,
or remove the functions using them from the old installation. A list of
problem libraries is in the file:
loadable_libraries.txt<\/code><\/p>\n\n\n\n

and checking the content of the loadable_libraries.txt file, you may see something like following:<\/p>\n\n\n\n

[postgres@localhost ~]$ cat loadable_libraries.txt
could not load library \"$libdir\/repmgr\": ERROR: could not access file \"$libdir\/repmgr\": No such file or directory
Database: postgres
Database: repmgr<\/code><\/p>\n\n\n\n

Resolution<\/strong><\/p>\n\n\n\n

In this case, when upgrading to a new version, it is necessary to install repmgr<\/em> in the new version as well, i.e., the utilities & extensions that were installed on the source Postgres version would also need to be installed on the target Postgres version to maintain consistency and compatibility.
We will recheck the same command once again and the result will be as follows.<\/p>\n\n\n\n

\"pg_upgrade
Image: pg_upgrade –check<\/figcaption><\/figure><\/div>\n\n\n\n

It\u2019s important to perform thorough testing after the upgrade to ensure the compatibility of your applications with the new version of PostgreSQL.<\/p>\n\n\n\n

Step 6:<\/strong> Perform actual upgrade<\/p>\n\n\n\n

[postgres@localhost data]$ \/usr\/pgsql-15\/bin\/pg_upgrade -b \/usr\/pgsql-11\/bin\/ -B \/usr\/pgsql-15\/bin\/ -d <\/code>\/var\/lib\/pgsql\/11\/data\/ -D \/var\/lib\/pgsql\/15\/data\/ -o ' -c config_file=\/var\/lib\/pgsql\/11\/data\/postgresql.conf' -O ' -c config_file=\/var\/lib\/pgsql\/15\/data\/postgresql.conf'<\/code>
<\/p>\n\n\n\n

Performing Upgrade
--------------------------
Analyzing all rows in the new cluster ok
Freezing all rows in the new cluster ok
Deleting files from new pg_xact ok
Copying old pg_xact to new server ok
Setting oldest XID for new cluster ok
Setting next transaction ID and epoch for new cluster ok
Deleting files from new pg_multixact\/offsets ok
Copying old pg_multixact\/offsets to new server ok
Deleting files from new pg_multixact\/members ok
Copying old pg_multixact\/members to new server ok
Setting next multixact ID and offset for new cluster ok
Resetting WAL archives ok
Setting frozenxid and minmxid counters in new cluster ok
Restoring global objects in the new cluster ok
Restoring database schemas in the new cluster ok
Copying user relation files ok
Setting next OID for new cluster ok<\/code>
Sync data directory to disk ok
Creating script to delete old cluster ok
Checking for extension updates ok
Upgrade Complete
-------------------------
Optimizer statistics are not transferred by pg_upgrade.
Once you start the new server, consider running:
\/usr\/pgsql-15\/bin\/vacuumdb --all --analyze-in-stages<\/code>

Running this script will delete the old cluster's data files:
.\/delete_old_cluster.sh<\/code>
<\/p>\n\n\n\n

\"pg_upgrade\"
Image: pg_upgrade<\/figcaption><\/figure><\/div>\n\n\n\n

Step 7: <\/strong>Start the PostgreSQL-15 cluster<\/p>\n\n\n\n

sudo systemctl start postgresql-15<\/code><\/p>\n\n\n\n

Step 8:<\/strong> verify PostgreSQL-15 Cluster after upgrade using the command vacuumdb --all --analyze-in-stages<\/code><\/p>\n\n\n\n

\"verify
Image: verify PostgreSQL cluster<\/figcaption><\/figure><\/div>\n\n\n\n

pg_upgrade<\/strong> provides a convenient upgrade method, it’s important to perform thorough testing after the upgrade to ensure the compatibility of your applications with the new version of PostgreSQL.
If you wish to remove the old cluster\u2019s data files, you can run .\/delete_old_cluster.sh<\/code> as the postgres<\/em> user.<\/p>\n\n\n\n

Conclusion<\/strong><\/h2>\n\n\n\n

Overall, pg_upgrade<\/strong> is a valuable tool for upgrading PostgreSQL databases, providing a seamless and efficient way to move from an older version to a newer one while preserving your data and minimizing downtime.<\/p>\n","protected":false},"excerpt":{"rendered":"

Why pg_upgrade? pg_upgrade is a utility provided by PostgreSQL that allows you to upgrade your database cluster from an older […]<\/p>\n","protected":false},"author":9,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"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":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-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":"","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-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":"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":""},"mobile":{"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":""}},"footnotes":""},"categories":[23,42],"tags":[],"class_list":["post-4137","post","type-post","status-publish","format-standard","hentry","category-postgresql-14","category-postgresql-15"],"yoast_head":"\nThe quick and easy way to upgrade Postgres using 'pg_upgrade' - OpenSource DB<\/title>\n<meta name=\"robots\" content=\"noindex, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"The quick and easy way to upgrade Postgres using 'pg_upgrade' - OpenSource DB\" \/>\n<meta property=\"og:description\" content=\"Why pg_upgrade? pg_upgrade is a utility provided by PostgreSQL that allows you to upgrade your database cluster from an older […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/test.opensource-db.in\/wp1\/the-quick-and-easy-way-to-upgrade-postgres-using-pg_upgrade\/\" \/>\n<meta property=\"og:site_name\" content=\"OpenSource DB\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/people\/OpenSource-DB\/100072970755470\/\" \/>\n<meta property=\"article:published_time\" content=\"2023-06-14T08:19:23+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-06-14T08:33:54+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/06\/pg_upgrade__check.png\" \/>\n<meta name=\"author\" content=\"Venkat Akhil\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@opensource_db\" \/>\n<meta name=\"twitter:site\" content=\"@opensource_db\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Venkat Akhil\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/the-quick-and-easy-way-to-upgrade-postgres-using-pg_upgrade\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/the-quick-and-easy-way-to-upgrade-postgres-using-pg_upgrade\/\"},\"author\":{\"name\":\"Venkat Akhil\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/person\/a37b142ecbf953189a4f9209b0b8d328\"},\"headline\":\"The quick and easy way to upgrade Postgres using ‘pg_upgrade’\",\"datePublished\":\"2023-06-14T08:19:23+00:00\",\"dateModified\":\"2023-06-14T08:33:54+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/the-quick-and-easy-way-to-upgrade-postgres-using-pg_upgrade\/\"},\"wordCount\":421,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#organization\"},\"image\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/the-quick-and-easy-way-to-upgrade-postgres-using-pg_upgrade\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/06\/pg_upgrade__check.png\",\"articleSection\":[\"PostgreSQL 14\",\"PostgreSQL 15\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/test.opensource-db.in\/wp1\/the-quick-and-easy-way-to-upgrade-postgres-using-pg_upgrade\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/the-quick-and-easy-way-to-upgrade-postgres-using-pg_upgrade\/\",\"url\":\"https:\/\/test.opensource-db.in\/wp1\/the-quick-and-easy-way-to-upgrade-postgres-using-pg_upgrade\/\",\"name\":\"The quick and easy way to upgrade Postgres using 'pg_upgrade' - OpenSource DB\",\"isPartOf\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/the-quick-and-easy-way-to-upgrade-postgres-using-pg_upgrade\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/the-quick-and-easy-way-to-upgrade-postgres-using-pg_upgrade\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/06\/pg_upgrade__check.png\",\"datePublished\":\"2023-06-14T08:19:23+00:00\",\"dateModified\":\"2023-06-14T08:33:54+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/the-quick-and-easy-way-to-upgrade-postgres-using-pg_upgrade\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/test.opensource-db.in\/wp1\/the-quick-and-easy-way-to-upgrade-postgres-using-pg_upgrade\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/the-quick-and-easy-way-to-upgrade-postgres-using-pg_upgrade\/#primaryimage\",\"url\":\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/06\/pg_upgrade__check.png\",\"contentUrl\":\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/06\/pg_upgrade__check.png\",\"width\":701,\"height\":437},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/the-quick-and-easy-way-to-upgrade-postgres-using-pg_upgrade\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/test.opensource-db.in\/wp1\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"The quick and easy way to upgrade Postgres using ‘pg_upgrade’\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#website\",\"url\":\"https:\/\/test.opensource-db.in\/wp1\/\",\"name\":\"OpenSource DB\",\"description\":\"Your Trusted OpenSource Databases partner\",\"publisher\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/test.opensource-db.in\/wp1\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#organization\",\"name\":\"OPENSOURCE DB PRIVATE LIMITED\",\"url\":\"https:\/\/test.opensource-db.in\/wp1\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2021\/10\/osdb-logo-tm-2.png\",\"contentUrl\":\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2021\/10\/osdb-logo-tm-2.png\",\"width\":368,\"height\":120,\"caption\":\"OPENSOURCE DB PRIVATE LIMITED\"},\"image\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/people\/OpenSource-DB\/100072970755470\/\",\"https:\/\/x.com\/opensource_db\",\"https:\/\/www.youtube.com\/channel\/UCmTI5h\",\"https:\/\/www.linkedin.com\/company\/opensource-db\",\"https:\/\/www.instagram.com\/opensource_db\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/person\/a37b142ecbf953189a4f9209b0b8d328\",\"name\":\"Venkat Akhil\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/522c0947d21b2c2c89f10698fd9131f9db4110f65c8d02b53d9b4559c7650865?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/522c0947d21b2c2c89f10698fd9131f9db4110f65c8d02b53d9b4559c7650865?s=96&d=mm&r=g\",\"caption\":\"Venkat Akhil\"},\"url\":\"https:\/\/test.opensource-db.in\/wp1\/author\/sudheer-sopensource-db-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"The quick and easy way to upgrade Postgres using 'pg_upgrade' - OpenSource DB","robots":{"index":"noindex","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"og_locale":"en_US","og_type":"article","og_title":"The quick and easy way to upgrade Postgres using 'pg_upgrade' - OpenSource DB","og_description":"Why pg_upgrade? pg_upgrade is a utility provided by PostgreSQL that allows you to upgrade your database cluster from an older […]","og_url":"https:\/\/test.opensource-db.in\/wp1\/the-quick-and-easy-way-to-upgrade-postgres-using-pg_upgrade\/","og_site_name":"OpenSource DB","article_publisher":"https:\/\/www.facebook.com\/people\/OpenSource-DB\/100072970755470\/","article_published_time":"2023-06-14T08:19:23+00:00","article_modified_time":"2023-06-14T08:33:54+00:00","og_image":[{"url":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/06\/pg_upgrade__check.png","type":"","width":"","height":""}],"author":"Venkat Akhil","twitter_card":"summary_large_image","twitter_creator":"@opensource_db","twitter_site":"@opensource_db","twitter_misc":{"Written by":"Venkat Akhil","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/test.opensource-db.in\/wp1\/the-quick-and-easy-way-to-upgrade-postgres-using-pg_upgrade\/#article","isPartOf":{"@id":"https:\/\/test.opensource-db.in\/wp1\/the-quick-and-easy-way-to-upgrade-postgres-using-pg_upgrade\/"},"author":{"name":"Venkat Akhil","@id":"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/person\/a37b142ecbf953189a4f9209b0b8d328"},"headline":"The quick and easy way to upgrade Postgres using ‘pg_upgrade’","datePublished":"2023-06-14T08:19:23+00:00","dateModified":"2023-06-14T08:33:54+00:00","mainEntityOfPage":{"@id":"https:\/\/test.opensource-db.in\/wp1\/the-quick-and-easy-way-to-upgrade-postgres-using-pg_upgrade\/"},"wordCount":421,"commentCount":0,"publisher":{"@id":"https:\/\/test.opensource-db.in\/wp1\/#organization"},"image":{"@id":"https:\/\/test.opensource-db.in\/wp1\/the-quick-and-easy-way-to-upgrade-postgres-using-pg_upgrade\/#primaryimage"},"thumbnailUrl":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/06\/pg_upgrade__check.png","articleSection":["PostgreSQL 14","PostgreSQL 15"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/test.opensource-db.in\/wp1\/the-quick-and-easy-way-to-upgrade-postgres-using-pg_upgrade\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/test.opensource-db.in\/wp1\/the-quick-and-easy-way-to-upgrade-postgres-using-pg_upgrade\/","url":"https:\/\/test.opensource-db.in\/wp1\/the-quick-and-easy-way-to-upgrade-postgres-using-pg_upgrade\/","name":"The quick and easy way to upgrade Postgres using 'pg_upgrade' - OpenSource DB","isPartOf":{"@id":"https:\/\/test.opensource-db.in\/wp1\/#website"},"primaryImageOfPage":{"@id":"https:\/\/test.opensource-db.in\/wp1\/the-quick-and-easy-way-to-upgrade-postgres-using-pg_upgrade\/#primaryimage"},"image":{"@id":"https:\/\/test.opensource-db.in\/wp1\/the-quick-and-easy-way-to-upgrade-postgres-using-pg_upgrade\/#primaryimage"},"thumbnailUrl":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/06\/pg_upgrade__check.png","datePublished":"2023-06-14T08:19:23+00:00","dateModified":"2023-06-14T08:33:54+00:00","breadcrumb":{"@id":"https:\/\/test.opensource-db.in\/wp1\/the-quick-and-easy-way-to-upgrade-postgres-using-pg_upgrade\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/test.opensource-db.in\/wp1\/the-quick-and-easy-way-to-upgrade-postgres-using-pg_upgrade\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/test.opensource-db.in\/wp1\/the-quick-and-easy-way-to-upgrade-postgres-using-pg_upgrade\/#primaryimage","url":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/06\/pg_upgrade__check.png","contentUrl":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/06\/pg_upgrade__check.png","width":701,"height":437},{"@type":"BreadcrumbList","@id":"https:\/\/test.opensource-db.in\/wp1\/the-quick-and-easy-way-to-upgrade-postgres-using-pg_upgrade\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/test.opensource-db.in\/wp1\/"},{"@type":"ListItem","position":2,"name":"The quick and easy way to upgrade Postgres using ‘pg_upgrade’"}]},{"@type":"WebSite","@id":"https:\/\/test.opensource-db.in\/wp1\/#website","url":"https:\/\/test.opensource-db.in\/wp1\/","name":"OpenSource DB","description":"Your Trusted OpenSource Databases partner","publisher":{"@id":"https:\/\/test.opensource-db.in\/wp1\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/test.opensource-db.in\/wp1\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/test.opensource-db.in\/wp1\/#organization","name":"OPENSOURCE DB PRIVATE LIMITED","url":"https:\/\/test.opensource-db.in\/wp1\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/logo\/image\/","url":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2021\/10\/osdb-logo-tm-2.png","contentUrl":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2021\/10\/osdb-logo-tm-2.png","width":368,"height":120,"caption":"OPENSOURCE DB PRIVATE LIMITED"},"image":{"@id":"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/people\/OpenSource-DB\/100072970755470\/","https:\/\/x.com\/opensource_db","https:\/\/www.youtube.com\/channel\/UCmTI5h","https:\/\/www.linkedin.com\/company\/opensource-db","https:\/\/www.instagram.com\/opensource_db\/"]},{"@type":"Person","@id":"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/person\/a37b142ecbf953189a4f9209b0b8d328","name":"Venkat Akhil","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/522c0947d21b2c2c89f10698fd9131f9db4110f65c8d02b53d9b4559c7650865?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/522c0947d21b2c2c89f10698fd9131f9db4110f65c8d02b53d9b4559c7650865?s=96&d=mm&r=g","caption":"Venkat Akhil"},"url":"https:\/\/test.opensource-db.in\/wp1\/author\/sudheer-sopensource-db-com\/"}]}},"rttpg_featured_image_url":null,"rttpg_author":{"display_name":"Venkat Akhil","author_link":"https:\/\/test.opensource-db.in\/wp1\/author\/sudheer-sopensource-db-com\/"},"rttpg_comment":0,"rttpg_category":"<a href=\"https:\/\/test.opensource-db.in\/wp1\/category\/postgres\/postgresql-14\/\" rel=\"category tag\">PostgreSQL 14<\/a> <a href=\"https:\/\/test.opensource-db.in\/wp1\/category\/postgres\/postgresql-15\/\" rel=\"category tag\">PostgreSQL 15<\/a>","rttpg_excerpt":"Why pg_upgrade? pg_upgrade is a utility provided by PostgreSQL that allows you to upgrade your database cluster from an older […]","_links":{"self":[{"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/posts\/4137","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/comments?post=4137"}],"version-history":[{"count":9,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/posts\/4137\/revisions"}],"predecessor-version":[{"id":4151,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/posts\/4137\/revisions\/4151"}],"wp:attachment":[{"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/media?parent=4137"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/categories?post=4137"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/tags?post=4137"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}