{"id":4175,"date":"2023-07-26T07:35:05","date_gmt":"2023-07-26T07:35:05","guid":{"rendered":"https:\/\/test.opensource-db.in\/wp1\/?p=4175"},"modified":"2023-10-26T03:22:22","modified_gmt":"2023-10-26T03:22:22","slug":"upgrading-to-pg15-using-pg_upgrade","status":"publish","type":"post","link":"https:\/\/test.opensource-db.in\/wp1\/upgrading-to-pg15-using-pg_upgrade\/","title":{"rendered":"Hey Barman Users! Upgrading to PG15 using pg_upgrade??"},"content":{"rendered":"\n<figure class=\"wp-block-image size-full is-resized is-style-default\"><img fetchpriority=\"high\" decoding=\"async\" width=\"512\" height=\"269\" src=\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/07\/image.png\" alt=\"\" class=\"wp-image-4196\" style=\"width:838px;height:440px\" srcset=\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/07\/image.png 512w, https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/07\/image-300x158.png 300w, https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/07\/image-188x99.png 188w, https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/07\/image-152x80.png 152w, https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/07\/image-394x207.png 394w\" sizes=\"(max-width: 512px) 100vw, 512px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Read this before, if you&#8217;re using Barman<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Introduction:<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">If you are using a Barman setup for backups in PostgreSQL and encounter errors while performing an upgrade from a lower version to PostgreSQL 15, there are several potential reasons and solutions to consider.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Here are one of the most common issue and troubleshooting steps with an example:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>We&#8217;ll explain the missing function `pg_stop_backup` and ACL that comes with pgBarman installation. Which causes the pg_upgrade to fail.<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Normally, during backup operations, Barman uses PostgreSQL native functions pg_start_backup and pg_stop_backup for concurrent backup.This is the recommended way of taking backups for PostgreSQL 9.6 and above (though note the functions have been renamed to pg_backup_start and pg_backup_stop in the PostgreSQL 15 beta).<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">pgBarman is a popular backup and recovery tool for PostgreSQL databases. It integrates with the PostgreSQL streaming replication feature and provides additional functionality for managing backups. During a PostgreSQL upgrade process, it is common to perform a backup using pgBarman before proceeding with the upgrade. This ensures that a reliable restore point is available in case any issues arise during the upgrade.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">When using pgBarman, the backup process involves two steps: starting the backup and stopping the backup.&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The pg_start_backup function is used to initiate the backup, and the pg_stop_backup function is used to finalize it.&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The pg_stop_backup function is crucial as it performs necessary operations to ensure data consistency and completeness in the backup.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Example:<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">In this case I have set up one primary node and one standby node running on PostgreSQL 11 version with streaming replication and also a barman setup with another node.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Performing upgradation pg 11 to pg 15 version using following command:<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>postgres@sudheer-vm:$\/usr\/lib\/postgresql\/15\/bin\/pg_upgrade \\ \n     --old-bindir \/usr\/lib\/postgresql\/11\/bin\/ \\\n     --new-bindir \/usr\/lib\/postgresql\/15\/bin\/ \\\n     --old-datadir \/var\/lib\/postgresql\/11\/main \\\n     --new-datadir \/var\/lib\/postgresql\/15\/main \\\n     --old-options '-c config_file=\/etc\/postgresql\/11\/main\/postgresql.conf' \\ \n     --new-options '-c config_file=\/etc\/postgresql\/15\/main\/postgresql.conf' \\ \n     --link \\\n     -\u2013check<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">If we encounter a success message similar to &#8220;Clusters are compatible,&#8221; it indicates that the clusters being referenced or compared are compatible with each other. Now that we have verified that the clusters are compatible, we can proceed with the pg_upgrade command and exclude the &#8220;&#8211;check&#8221; option.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>postgres@sudheer-vm:$\/usr\/lib\/postgresql\/15\/bin\/pg_upgrade \\ \n     --old-bindir \/usr\/lib\/postgresql\/11\/bin\/ \\\n     --new-bindir \/usr\/lib\/postgresql\/15\/bin\/ \\\n     --old-datadir \/var\/lib\/postgresql\/11\/main \\\n     --new-datadir \/var\/lib\/postgresql\/15\/main \\\n     --old-options '-c config_file=\/etc\/postgresql\/11\/main\/postgresql.conf' \\ \n     --new-options '-c config_file=\/etc\/postgresql\/15\/main\/postgresql.conf' \\ \n     --link<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">You may encounter an error similar to the one below.&nbsp;&nbsp;&nbsp;<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>*failure*\nConsult the last few lines of \"\/var\/lib\/postgresql\/15\/main\/pg_upgrade_output.d\/20230719T234750.599\/log\/pg_upgrade_dump_13190.log\" for\nthe probable cause of the failure.\nFailure, exiting\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">We can identify the error in the as displayed in the following screenshot<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><img decoding=\"async\" style=\"\" src=\"https:\/\/lh3.googleusercontent.com\/WMBLzqq6mFJC46yVaVe6MvMhERVmFy-C-E_ZHkT6HeROUGvqALUlwHWD09x4PJ7Rnwh2Pj82xSZas7ybCW1uTSXFwrNANDGJosQXvoO9yfdHS9XE8V6Jy8QUxybuOtEr8jQNKzsw4bJxEB8JLF1_ooCbK8hbZBHR\"><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>postgres@sudheer-vm:$ vi \/var\/lib\/postgresql\/15\/main\/pg_upgrade_output.d\/20230719T234750.599\/log\/pg_upgrade_dump_13190.log<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">We can identify the error in the pg_upgrade error log, as displayed in the following screenshot.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><img decoding=\"async\" src=\"https:\/\/lh3.googleusercontent.com\/1vLh2mOLunZNj477dJke0MtELuuBc_lhbYP7Zc_SHIXL_G8rYuT4LjVyCBWSihOT7M8GCr_GJpdkzle45VgXXbaYVK5DUNZcpa8LPNoc5ZXeMLrXkqDmRQoXQH4WiZYpq3xhHsbZdzPAQ6MTXo1ki8XM5UHCXOXn\" style=\"\"><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Resolution:<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Step1 : <\/strong>We need to&nbsp; set up the replication from Primary to the Standby<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Step2 : <\/strong>Install the PostgreSQL 15 version in the standby server<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Step3 : <\/strong>Stop the replication between Primary and Standby&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Step4 : <\/strong>Promote the standby server PostgreSQL 11<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Step5 : <\/strong>Drop the user BARMAN in PostgreSQL 11 with previous privillages<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Step6 : <\/strong>Stop both the clusters PostgreSQL 11 and PostgreSQL 15<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Now we can perform the pg_upgrade command with the &#8211;check option to test whether the clusters are compatible or not. For command please refer above pg_upgrade command .<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">If we encounter a success message similar to &#8220;Clusters are compatible,&#8221; it indicates that the clusters being referenced or compared are compatible with each other.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Now that we have verified that the clusters are compatible, we can proceed with the pg_upgrade command and exclude the &#8220;&#8211;check&#8221; option .<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The upgrade process is completed, and now we need to collect all the statistics of the old cluster data files using the following command. Before running this command, make sure to start the new cluster pg15.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>postgres@sudheer-vm:$ systemctl start postgresql@15-main.service<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>postgres@sudheer-vm:\/usr\/lib\/postgresql\/15$ \/usr\/lib\/postgresql\/15\/bin\/vacuumdb -U postgres --all --analyze-in-stages<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">As displayed in the following screenshot<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><img decoding=\"async\" src=\"https:\/\/lh4.googleusercontent.com\/pKEWY2ft7GwoFiwuZlnBb0hT1gpDRE93Ki7L0vpfOxWLFASajVBA7krsDMf0vETQE45hQEY6ZFxWG9ZejxFbMmqFr07SNAVdqNFFcLQ7ILmJ5gJansqx33AIBOxqsuc_ocajlBUN-9XKog82ZqCtJpc\" style=\"\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Create BARMAN user as following<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>postgres@sudheer-vm:\/usr\/lib\/postgresql\/15$ createuser -P barman\nEnter password for new role:\nEnter it again:<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">login to psql and grant all the privileges on the required functions to barman user as following<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>postgres@sudheer-vm:\/usr\/lib\/postgresql\/15$ psql\npsql (15.3 (Ubuntu 15.3-1.pgdg22.04+1))\npostgres=# GRANT EXECUTE ON FUNCTION pg_backup_start(text, boolean) to barman;\nGRANT EXECUTE ON FUNCTION pg_backup_stop(boolean) to barman;\nGRANT EXECUTE ON FUNCTION pg_switch_wal() to barman;\nGRANT EXECUTE ON FUNCTION pg_create_restore_point(text) to barman;\nGRANT pg_read_all_settings TO barman;\nGRANT pg_read_all_stats TO barman;\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">As displayed in the following screenshot :&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><img decoding=\"async\" src=\"https:\/\/lh3.googleusercontent.com\/ArZNLVQ8vImYaB635Qd_JhR5sQj4ZYQq3rez71p2u6NPoNfXfba1oetA7qas24qRaeHpEiHrMeaPBXNaT58zSJUJn-o4rP3PRi1Im5bjvVXi3_13WoXzKa_Ym59wQETn2VMVWFTCcfhiUlHkYMP9iEA\" style=\"\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Now we can check all the data files available in the upgraded version cluster.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><img decoding=\"async\" src=\"https:\/\/lh4.googleusercontent.com\/sBgqxaKftglTzhEHnvKvFN3Tm8U8WyNhKcQQ3vg0AH3wdwbhkR-lpxxQmZ4DBwWzD5vu-VmK3s2DuyTRYvaRKugNx8kELVWujlWvfB6tFzKKLppGlmLqCVkluTXxBgsp0u_8PeVzxfaPOxOGN3S5xHg\" style=\"\"><\/strong><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Conclusion:<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">pg_start_backup (and pg_backup_start in PostgreSQL 15 ): This function is used to start a base backup in PostgreSQL. When invoked, it puts the database into backup mode, allowing backup tools like Barman to take a consistent backup of the database files while the server continues to handle normal operations. Any changes made during the backup process are recorded separately so that the backup is transitionally consistent.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">pg_stop_backup (and pg_backup_stop in PostgreSQL 15 ): This function is used to finish the base backup started with pg_start_backup. Once called, it takes the database out of backup mode and completes the backup process.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Using these functions in Barman ensures that the backups are taken in a safe and concurrent manner without causing disruptions to the production PostgreSQL database.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Read this before, if you&#8217;re using Barman Introduction: If you are using a Barman setup for backups in PostgreSQL and [&hellip;]<\/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-4175","post","type-post","status-publish","format-standard","hentry","category-postgresql-14","category-postgresql-15"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Hey Barman Users! Upgrading to PG15 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=\"Hey Barman Users! Upgrading to PG15 using pg_upgrade?? - OpenSource DB\" \/>\n<meta property=\"og:description\" content=\"Read this before, if you&#8217;re using Barman Introduction: If you are using a Barman setup for backups in PostgreSQL and [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/test.opensource-db.in\/wp1\/upgrading-to-pg15-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-07-26T07:35:05+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-10-26T03:22:22+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/07\/image.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\/upgrading-to-pg15-using-pg_upgrade\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/upgrading-to-pg15-using-pg_upgrade\/\"},\"author\":{\"name\":\"Venkat Akhil\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/person\/a37b142ecbf953189a4f9209b0b8d328\"},\"headline\":\"Hey Barman Users! Upgrading to PG15 using pg_upgrade??\",\"datePublished\":\"2023-07-26T07:35:05+00:00\",\"dateModified\":\"2023-10-26T03:22:22+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/upgrading-to-pg15-using-pg_upgrade\/\"},\"wordCount\":748,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#organization\"},\"image\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/upgrading-to-pg15-using-pg_upgrade\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/07\/image.png\",\"articleSection\":[\"PostgreSQL 14\",\"PostgreSQL 15\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/test.opensource-db.in\/wp1\/upgrading-to-pg15-using-pg_upgrade\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/upgrading-to-pg15-using-pg_upgrade\/\",\"url\":\"https:\/\/test.opensource-db.in\/wp1\/upgrading-to-pg15-using-pg_upgrade\/\",\"name\":\"Hey Barman Users! Upgrading to PG15 using pg_upgrade?? - OpenSource DB\",\"isPartOf\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/upgrading-to-pg15-using-pg_upgrade\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/upgrading-to-pg15-using-pg_upgrade\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/07\/image.png\",\"datePublished\":\"2023-07-26T07:35:05+00:00\",\"dateModified\":\"2023-10-26T03:22:22+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/upgrading-to-pg15-using-pg_upgrade\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/test.opensource-db.in\/wp1\/upgrading-to-pg15-using-pg_upgrade\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/upgrading-to-pg15-using-pg_upgrade\/#primaryimage\",\"url\":\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/07\/image.png\",\"contentUrl\":\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/07\/image.png\",\"width\":512,\"height\":269},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/upgrading-to-pg15-using-pg_upgrade\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/test.opensource-db.in\/wp1\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Hey Barman Users! Upgrading to PG15 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":"Hey Barman Users! Upgrading to PG15 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":"Hey Barman Users! Upgrading to PG15 using pg_upgrade?? - OpenSource DB","og_description":"Read this before, if you&#8217;re using Barman Introduction: If you are using a Barman setup for backups in PostgreSQL and [&hellip;]","og_url":"https:\/\/test.opensource-db.in\/wp1\/upgrading-to-pg15-using-pg_upgrade\/","og_site_name":"OpenSource DB","article_publisher":"https:\/\/www.facebook.com\/people\/OpenSource-DB\/100072970755470\/","article_published_time":"2023-07-26T07:35:05+00:00","article_modified_time":"2023-10-26T03:22:22+00:00","og_image":[{"url":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/07\/image.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\/upgrading-to-pg15-using-pg_upgrade\/#article","isPartOf":{"@id":"https:\/\/test.opensource-db.in\/wp1\/upgrading-to-pg15-using-pg_upgrade\/"},"author":{"name":"Venkat Akhil","@id":"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/person\/a37b142ecbf953189a4f9209b0b8d328"},"headline":"Hey Barman Users! Upgrading to PG15 using pg_upgrade??","datePublished":"2023-07-26T07:35:05+00:00","dateModified":"2023-10-26T03:22:22+00:00","mainEntityOfPage":{"@id":"https:\/\/test.opensource-db.in\/wp1\/upgrading-to-pg15-using-pg_upgrade\/"},"wordCount":748,"commentCount":0,"publisher":{"@id":"https:\/\/test.opensource-db.in\/wp1\/#organization"},"image":{"@id":"https:\/\/test.opensource-db.in\/wp1\/upgrading-to-pg15-using-pg_upgrade\/#primaryimage"},"thumbnailUrl":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/07\/image.png","articleSection":["PostgreSQL 14","PostgreSQL 15"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/test.opensource-db.in\/wp1\/upgrading-to-pg15-using-pg_upgrade\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/test.opensource-db.in\/wp1\/upgrading-to-pg15-using-pg_upgrade\/","url":"https:\/\/test.opensource-db.in\/wp1\/upgrading-to-pg15-using-pg_upgrade\/","name":"Hey Barman Users! Upgrading to PG15 using pg_upgrade?? - OpenSource DB","isPartOf":{"@id":"https:\/\/test.opensource-db.in\/wp1\/#website"},"primaryImageOfPage":{"@id":"https:\/\/test.opensource-db.in\/wp1\/upgrading-to-pg15-using-pg_upgrade\/#primaryimage"},"image":{"@id":"https:\/\/test.opensource-db.in\/wp1\/upgrading-to-pg15-using-pg_upgrade\/#primaryimage"},"thumbnailUrl":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/07\/image.png","datePublished":"2023-07-26T07:35:05+00:00","dateModified":"2023-10-26T03:22:22+00:00","breadcrumb":{"@id":"https:\/\/test.opensource-db.in\/wp1\/upgrading-to-pg15-using-pg_upgrade\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/test.opensource-db.in\/wp1\/upgrading-to-pg15-using-pg_upgrade\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/test.opensource-db.in\/wp1\/upgrading-to-pg15-using-pg_upgrade\/#primaryimage","url":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/07\/image.png","contentUrl":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/07\/image.png","width":512,"height":269},{"@type":"BreadcrumbList","@id":"https:\/\/test.opensource-db.in\/wp1\/upgrading-to-pg15-using-pg_upgrade\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/test.opensource-db.in\/wp1\/"},{"@type":"ListItem","position":2,"name":"Hey Barman Users! Upgrading to PG15 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":"Read this before, if you&#8217;re using Barman Introduction: If you are using a Barman setup for backups in PostgreSQL and [&hellip;]","_links":{"self":[{"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/posts\/4175","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=4175"}],"version-history":[{"count":16,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/posts\/4175\/revisions"}],"predecessor-version":[{"id":4606,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/posts\/4175\/revisions\/4606"}],"wp:attachment":[{"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/media?parent=4175"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/categories?post=4175"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/tags?post=4175"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}