Thread: Upgrade for primary standby config
Hello All,
Please provide me with the high level steps for upgrade in postgres from 11 to 15 version for primary-standby configuration setup.
Thanks,
Sid
On Fri, 2025-01-03 at 06:21 +0530, Siddhartha Jain wrote: > Please provide me with the high level steps for upgrade in postgres from 11 to 15 version > for primary-standby configuration setup. You cannot use a streaming replication standby server; you have to use logical replication. - set up a logical replication standby server - wait until replication has caught up - stop your application - set the sequences on the subscriber (they are not replicated) - drop the subscription - make the application run with the new database I recommend that you use pg_upgrade rather than logical replication. Yours, Laurenz Albe
On Fri, Jan 3, 2025 at 3:21 AM Laurenz Albe <laurenz.albe@cybertec.at> wrote:
On Fri, 2025-01-03 at 06:21 +0530, Siddhartha Jain wrote:
> Please provide me with the high level steps for upgrade in postgres from 11 to 15 version
> for primary-standby configuration setup.
You cannot use a streaming replication standby server; you have to use logical replication.
Or does OP mean that he wants to upgrade both the primary and replica at the same time?
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!