On Sun, Nov 24, 2024 at 11:05 AM Subhash Udata <subhashud...@gmail.com>
wrote:

> Dear PostgreSQL Community,
>
> I have a production database setup with a primary server and a standby
> server. The database is currently running on *PostgreSQL 15.0*, and I
> plan to upgrade both servers to *15.9*.
>
> I have the following questions regarding the upgrade and replication
> process:
>
>    1.
>
>    *Upgrade and Replication Compatibility*:
>    - My plan is to perform a failover, promote the standby server
>       (currently 15.0) to primary, and then upgrade the old primary server to
>       version 15.9.
>
>
Try to replicate from old->new version, because bug fixes in newer versions
might have broken something in new->old replication.

If you really can't tolerate any downtime, then shutdown and upgrade the
Secondary server from 15.0 to 15.10.  Once you start it back up,
replication from the still-15.0 primary will catch back up to the
now-patched Secondary.

Fail over to the Secondary (now new-Primary), and then patch old-Primary to
15.10.


>
>    1.
>       - After upgrading the old primary server to version 15.9, I want to
>       configure it as a standby server and set up streaming replication with 
> the
>       new primary server, which will still be running version 15.0.
>       - Is it possible to establish streaming replication between these
>       two versions (*15.0* as primary and *15.9* as standby)?
>    2.
>
>    *Efficient Replication Setup*:
>    - The production database is around *1TB in size*, and creating
>       replication using pg_basebackup is taking more than 2–3 hours to
>       complete.
>       - Is there an alternative method to set up replication without
>       taking a full backup of the entire cluster but instead using only the 
> WAL
>       files that have changed on both servers?
>
>
pg_rewind is probably what you want.  I've never used it, though.

-- 
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

Reply via email to