Στις 18/11/24 19:26, ο/η Ron Johnson έγραψε:
No. Neither rsync nor streaming replication will do version upgrades.
The only ways to do version upgrade are:
1. pg_dump + pg_restore
2. pg_upgrade
3. Logical replication
I'd like to add if someone can tolerate some seconds of downtime, with logical replication it is possible to swap the roles of publisher / subscriber so that one can keep the old database as a means of extra safety. If his/her app breaks beyond repair and there is no time for fixing, one can simply go back to the old DB with some minor adjustments (such as sequences).
Thanks Ron for your suggestion.
So for pg upgrade in streaming replication setup, rsync will be a better option for standby upgrade if we are using --link option or recreating the standby, once upgrade completes on primary? Any suggestions on this please.
Best Regards,
Raman
Dear Team,
We are in the process of upgrading our PostgreSQL database from version 12 to version 15. I would greatly appreciate your advice on the following:
1. Would it be recommended to use the --link option with the pg_upgrade command, from disk space point of view?
Yes.
Are there any potential downsides to consider?
Very much: it's a one-way journey. No rolling back if something goes wrong!
2. Do you have any suggestions or best practices for performing an efficient upgrade in a replication setup (streaming replication) for both the primary and standby servers?
Streaming replication is not an upgrade method. Logical replication is absolutely a valid method of upgrading PG on one server to PG on a different server.
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
-- Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
