Re: Upgrade for primary standby config

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