Date: Fri, 17 Feb 2023 15:01:35 +0530
From: Karthik Krishnakumar <karthikk@zohocorp.com>
To: "pgsql-admin" <pgsql-admin@lists.postgresql.org>
Message-Id: <1865eb25ef2.12bfda8e286305.6340275209123460062@zohocorp.com>
In-Reply-To: 
Subject: Upgrading postgres quickly, without downtime.
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_280221_339066876.1676625993458"
Importance: Medium
User-Agent: Zoho Mail
Archived-At: 
 <https://www.postgresql.org/message-id/1865eb25ef2.12bfda8e286305.6340275209123460062%40zohocorp.com>
Precedence: bulk

------=_Part_280221_339066876.1676625993458
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Hi admins,


I have a number of pg servers(~100 (each with a couple of replicas, so 300 =
clusters in total), each with ~2TB data) that is running version 10.

I am planning on upgrading to PG 15 and looking for ways to get it done wit=
hout downtime and quickly.=20

There seem to be a couple of ways to do this -=20

1. dump/restore or upgrade -> but this causes downtime.=20

2. logical replication/pglogical -> this is going to be slow, adds addition=
al load on the master, and it isnt recommended to do DDL during time.=20


I do have daily backups of these databases.=20

Is there a way I can use these daily backups to upgrade to 15 and sync the =
changes for the day alone?=20

I can code in C/scripts, and know bit of internals and wanted to ask where =
to start on this.=20

I am also open to any alternate ideas.=C2=A0


thanks

karthik
------=_Part_280221_339066876.1676625993458
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html><head>=
<meta content=3D"text/html;charset=3DUTF-8" http-equiv=3D"Content-Type"></h=
ead><body ><div style=3D"font-size: 10pt;"><div>Hi admins,<br></div><div><b=
r></div><div>I have a number of pg servers(~100 (each with a couple of repl=
icas, so 300 clusters in total), each with ~2TB data) that is running versi=
on 10.<br></div><div>I am planning on upgrading to PG 15 and looking for wa=
ys to get it done without downtime and quickly. <br></div><div>There seem t=
o be a couple of ways to do this - <br></div><div>1. dump/restore or upgrad=
e -&gt; but this causes downtime. <br></div><div>2. logical replication/pgl=
ogical -&gt; this is going to be slow, adds additional load on the master, =
and it isnt recommended to do DDL during time. <br></div><div><br></div><di=
v>I do have daily backups of these databases. <br></div><div>Is there a way=
 I can use these daily backups to upgrade to 15 and sync the changes for th=
e day alone? <br></div><div>I can code in C/scripts, and know bit of intern=
als and wanted to ask where to start on this. <br></div><div>I am also open=
 to any alternate ideas.&nbsp;<br></div><div><br></div><div>thanks<br></div=
><div>karthik<br></div><div><br></div><div><br></div></div><br></body></htm=
l>
------=_Part_280221_339066876.1676625993458--