On 11/24/24 08:36, Subhash Udata wrote:
The reason to upgrade from 15.0 to 15.9 is this
https://www.postgresql.org/support/security/CVE-2024-10979/
<https://www.postgresql.org/support/security/CVE-2024-10979/>
Here it is mentioned that this vulnerability is fixed in 15.9
So our organization wants an upgrade from 15.0 to 15.9
Sorry, I was not clear enough. When I said 'Why?' it was not referring
to reason you wanted to upgrade, it was why go through the whole
pg_basebackup process. Read this link:
https://www.postgresql.org/support/versioning/
for why that is not necessary.
On Sun, 24 Nov 2024 at 21:48, Adrian Klaver <adrian.kla...@aklaver.com
<mailto:adrian.kla...@aklaver.com>> wrote:
On 11/24/24 08:05, Subhash Udata 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.
> * 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?
Why?
15.0 --> 15.9(actually you want the latest release 15.10) is a minor
upgrade it involves shutting down the servers installing the new
version
binaries on each and restarting them.
You should read:
https://www.postgresql.org/support/versioning/
<https://www.postgresql.org/support/versioning/>
It would be a good idea to go through the Release Notes here:
https://www.postgresql.org/docs/15/release.html
<https://www.postgresql.org/docs/15/release.html>
To see what changed.
>
> Your guidance and recommendations on these questions will be greatly
> appreciated.
>
> Thank you for your time and support!
>
> Best regards,
>
> Subhash
>
--
Adrian Klaver
adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com>
--
Adrian Klaver
adrian.kla...@aklaver.com
