Questions on Upgrading PostgreSQL from 15.0 to 15.9 and Setting Up Streaming Replication

From: Subhash Udata <subhashudata(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Questions on Upgrading PostgreSQL from 15.0 to 15.9 and Setting Up Streaming Replication
Date: 2024-11-24 16:05:15
Message-ID: CAD=40Z3Rvbx46SxYBBdLvgSObXCP+Firszz++rDTXmGX795D2Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.
- 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?

Your guidance and recommendations on these questions will be greatly
appreciated.

Thank you for your time and support!

Best regards,

Subhash

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2024-11-24 16:18:49 Re: Questions on Upgrading PostgreSQL from 15.0 to 15.9 and Setting Up Streaming Replication
Previous Message Ron Johnson 2024-11-24 02:04:03 Re: CVE-2024-10979 Vulnerability Impact on PostgreSQL 11.10