MIME-Version: 1.0
From: Subhash Udata <subhashudata@gmail.com>
Date: Sun, 24 Nov 2024 21:35:15 +0530
Message-ID: <CAD=40Z3Rvbx46SxYBBdLvgSObXCP+Firszz++rDTXmGX795D2Q@mail.gmail.com>
Subject: Questions on Upgrading PostgreSQL from 15.0 to 15.9 and Setting Up
 Streaming Replication
To: pgsql-general@postgresql.org
Content-Type: multipart/alternative; boundary="000000000000bda3540627aac875"
Archived-At: <https://www.postgresql.org/message-id/CAD%3D40Z3Rvbx46SxYBBdLvgSObXCP%2BFirszz%2B%2BrDTXmGX795D2Q%40mail.gmail.com>
Precedence: bulk

--000000000000bda3540627aac875
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

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=E2=80=933 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 fi=
les
      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

--000000000000bda3540627aac875
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><p>Dear PostgreSQL Community,</p><p>I have a production da=
tabase setup with a primary server and a standby server. The database is cu=
rrently running on <strong>PostgreSQL 15.0</strong>, and I plan to upgrade =
both servers to <strong>15.9</strong>.</p><p>I have the following questions=
 regarding the upgrade and replication process:</p><ol><li><p><strong>Upgra=
de and Replication Compatibility</strong>:</p><ul><li>My plan is to perform=
 a failover, promote the standby server (currently 15.0) to primary, and th=
en upgrade the old primary server to version 15.9.</li><li>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.</li><li>Is it possible to establish st=
reaming replication between these two versions (<strong>15.0</strong> as pr=
imary and <strong>15.9</strong> as standby)?</li></ul></li><li><p><strong>E=
fficient Replication Setup</strong>:</p><ul><li>The production database is =
around <strong>1TB in size</strong>, and creating replication using <code>p=
g_basebackup</code> is taking more than 2=E2=80=933 hours to complete.</li>=
<li>Is there an alternative method to set up replication without taking a f=
ull backup of the entire cluster but instead using only the WAL files that =
have changed on both servers?</li></ul></li></ol><p>Your guidance and recom=
mendations on these questions will be greatly appreciated.</p><p>Thank you =
for your time and support!</p><p>Best regards,</p><p>Subhash</p></div>

--000000000000bda3540627aac875--