Comments on: Fast Upgrade of Legacy PostgreSQL with Minimum Downtime Using pg_upgrade https://www.percona.com/blog/fast-upgrade-of-legacy-postgresql-with-minimum-downtime-using-pg_upgrade/ Wed, 17 Mar 2021 17:16:29 +0000 hourly 1 https://wordpress.org/?v=6.5.2 By: Christian ROUX https://www.percona.com/blog/fast-upgrade-of-legacy-postgresql-with-minimum-downtime-using-pg_upgrade/#comment-10973085 Wed, 17 Mar 2021 17:16:29 +0000 https://www.percona.com/blog/?p=56295#comment-10973085 Hello. Thanks for your reply. You are right. I’m new on PG 12 and I had forgotten pg_checksum.

]]> By: Jobin Augustine https://www.percona.com/blog/fast-upgrade-of-legacy-postgresql-with-minimum-downtime-using-pg_upgrade/#comment-10973084 Wed, 17 Mar 2021 13:16:22 +0000 https://www.percona.com/blog/?p=56295#comment-10973084 I believe you are asking from application portability perspective.There won’t be any major syntax changes. As long as you stick to standard ANSI SQL syntax, there is very less chance that something will break in application. As you know PostgreSQL is one of the most standard compliant database. But testing is essential if you are planning to upgrade.
However there could be lot changes from Administrative and monitoring perspective, which majorly affects DBAs. The internal catalog views / functions can change which may affect the DBAs and their scripts.

]]> By: Jobin Augustine https://www.percona.com/blog/fast-upgrade-of-legacy-postgresql-with-minimum-downtime-using-pg_upgrade/#comment-10973083 Wed, 17 Mar 2021 13:08:59 +0000 https://www.percona.com/blog/?p=56295#comment-10973083 @Christian, You may upgrade to PostgreSQL 12 using pg_upgrade (without checksum) and then use the pg_checksums utility avaliable form PG12 (https://www.postgresql.org/docs/12/app-pgchecksums.html) to quickly enable the checksum.

]]> By: Christian ROUX https://www.percona.com/blog/fast-upgrade-of-legacy-postgresql-with-minimum-downtime-using-pg_upgrade/#comment-10973081 Tue, 16 Mar 2021 15:39:10 +0000 https://www.percona.com/blog/?p=56295#comment-10973081 Hi. Is there a way with pg_upgrade to migrate from a PostgreSQL 10 or 11 without data checksum to a PostgreSQL 12 version with data checksum or should I use or pg_dump/pg_restore/pg_dumpall or logical replication ?
Thanks you for your exellent blog.

Christian

]]> By: Jobin Augustine https://www.percona.com/blog/fast-upgrade-of-legacy-postgresql-with-minimum-downtime-using-pg_upgrade/#comment-10972846 Mon, 23 Nov 2020 09:48:49 +0000 https://www.percona.com/blog/?p=56295#comment-10972846 pg_upgrade will automatically provide a script at the end of execution for deleting the old cluster. please use the same.

]]> By: J Thomas https://www.percona.com/blog/fast-upgrade-of-legacy-postgresql-with-minimum-downtime-using-pg_upgrade/#comment-10972843 Fri, 20 Nov 2020 21:39:31 +0000 https://www.percona.com/blog/?p=56295#comment-10972843 Wondering if there will be any syntaxual changes to expect from say, 9.6 – 11?

]]> By: Sanjay https://www.percona.com/blog/fast-upgrade-of-legacy-postgresql-with-minimum-downtime-using-pg_upgrade/#comment-10972636 Mon, 17 Aug 2020 08:06:45 +0000 https://www.percona.com/blog/?p=56295#comment-10972636 Hi Team, Thanks for the article! Can we delete old data directory after we hard link it to new one?

]]>