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
