Message-ID: <28454b4ba1d1cad92d6eb40e68265c728b0c830f.camel@cybertec.at>
Subject: Re: Upgrading postgres quickly, without downtime.
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Karthik Krishnakumar <karthikk@zohocorp.com>, pgsql-admin
	 <pgsql-admin@lists.postgresql.org>
Date: Fri, 17 Feb 2023 13:13:32 +0100
In-Reply-To: <1865eb25ef2.12bfda8e286305.6340275209123460062@zohocorp.com>
References: <1865eb25ef2.12bfda8e286305.6340275209123460062@zohocorp.com>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.46.3 (3.46.3-1.fc37) 
MIME-Version: 1.0
Archived-At: 
 <https://www.postgresql.org/message-id/28454b4ba1d1cad92d6eb40e68265c728b0c830f.camel%40cybertec.at>
Precedence: bulk

On Fri, 2023-02-17 at 15:01 +0530, Karthik Krishnakumar wrote:
> I have a number of pg servers(~100 (each with a couple of replicas, so 30=
0
> 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
> without 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 additi=
onal
>    load on the master, and it isnt recommended to do DDL during time.=20
>=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 th=
e changes for the day alone?=20
> I can code in C/scripts, and know bit of internals and wanted to ask wher=
e to start on this.=20
> I am also open to any alternate ideas.=C2=A0

Take 10 minutes downtime and use "pg_upgrade --link".

Yours,
Laurenz Albe