Content-Type: text/plain;
	charset=utf-8
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3826.200.121\))
Subject: Re: Guidance Needed for PostgreSQL Upgrade from 12 to 15
From: Scott Ribe <scott_ribe@elevated-dev.com>
In-Reply-To: <355729f6-74a0-1b5c-a065-bd919507a490@vianet.ca>
Date: Tue, 19 Nov 2024 10:42:42 -0700
Cc: pgsql-admin@lists.postgresql.org
Content-Transfer-Encoding: quoted-printable
Message-Id: <39901423-2003-493F-8A5C-12D1B1062F00@elevated-dev.com>
References: 
 <CAL5GnisA0RJ=Rd5e6yw4nsCB+DtAS1=iquBKTH76MknnTsHrPg@mail.gmail.com>
 <CANzqJaA1VyGqPUQaeT9vfxNV1C3rQJSdMHa9xtzx+rJQhkY2gw@mail.gmail.com>
 <CAL5Gnitdyw7vCp4-0whmmJ-RC7Z9yQVx=xrtfQO6-Lxcfvqrqw@mail.gmail.com>
 <CANzqJaAL-vn0iwP8QGEcVn9RqLv9Uw12qG6fV0h5+AkwW1oGBQ@mail.gmail.com>
 <0b8c1b80-93f5-40a7-b67b-19e58207c12c@cloud.gatewaynet.com>
 <9724B260-8B0E-4B03-A66A-784F792459C9@elevated-dev.com>
 <355729f6-74a0-1b5c-a065-bd919507a490@vianet.ca>
To: Kris Deugau <kdeugau@vianet.ca>
Archived-At: 
 <https://www.postgresql.org/message-id/39901423-2003-493F-8A5C-12D1B1062F00%40elevated-dev.com>
Precedence: bulk

> On Nov 19, 2024, at 10:32=E2=80=AFAM, Kris Deugau <kdeugau@vianet.ca> =
wrote:
>=20
> as otherwise the old PG won't start properly, due to the changes made =
by pg_upgrade.

Not true, pg_upgrade leaves it in a state where either can be started. =
By taking the snapshot after, if you roll back to it, you can attempt =
changes on either the old or new. (Taking care to take additional =
snapshots as needed, to preserve the ability to roll back to this =
state.)