public inbox for [email protected]  

help / color / mirror / Atom feed

Upgrade for primary standby config
3+ messages / 3 participants
[nested] [flat]

* Upgrade for primary standby config
@ 2025-01-03 00:51  Siddhartha Jain <[email protected]>
  0 siblings, 1 reply; 3+ messages in thread

From: Siddhartha Jain @ 2025-01-03 00:51 UTC (permalink / raw)
  To: [email protected]

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


^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Upgrade for primary standby config
@ 2025-01-03 08:21  Laurenz Albe <[email protected]>
  parent: Siddhartha Jain <[email protected]>
  0 siblings, 1 reply; 3+ messages in thread

From: Laurenz Albe @ 2025-01-03 08:21 UTC (permalink / raw)
  To: Siddhartha Jain <[email protected]>; [email protected]

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





^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Upgrade for primary standby config
@ 2025-01-03 08:31  Ron Johnson <[email protected]>
  parent: Laurenz Albe <[email protected]>
  0 siblings, 0 replies; 3+ messages in thread

From: Ron Johnson @ 2025-01-03 08:31 UTC (permalink / raw)
  To: Pgsql-admin <[email protected]>

On Fri, Jan 3, 2025 at 3:21 AM Laurenz Albe <[email protected]>
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!


^ permalink  raw  reply  [nested|flat] 3+ messages in thread

end of thread, other threads:[~2025-01-03 08:31 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2025-01-03 00:51 Upgrade for primary standby config Siddhartha Jain <[email protected]>
2025-01-03 08:21 ` Laurenz Albe <[email protected]>
2025-01-03 08:31   ` Ron Johnson <[email protected]>

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox