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: <46c1255a-725f-3f0d-a18f-e1a9c20dd36e@vianet.ca>
Date: Tue, 19 Nov 2024 14:16:47 -0700
Cc: pgsql-admin@lists.postgresql.org
Content-Transfer-Encoding: quoted-printable
Message-Id: <5720FA08-368D-4A8C-B160-A104D08C829B@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>
 <39901423-2003-493F-8A5C-12D1B1062F00@elevated-dev.com>
 <46c1255a-725f-3f0d-a18f-e1a9c20dd36e@vianet.ca>
To: Kris Deugau <kdeugau@vianet.ca>
Archived-At: 
 <https://www.postgresql.org/message-id/5720FA08-368D-4A8C-B160-A104D08C829B%40elevated-dev.com>
Precedence: bulk

> On Nov 19, 2024, at 1:40=E2=80=AFPM, Kris Deugau <kdeugau@vianet.ca> =
wrote:
>=20
> I stand corrected.  I hadn't read the docs on pg_upgrade for quite a =
while, but after reading the last section in =
https://www.postgresql.org/docs/current/pgupgrade.html:
>=20
> "If you did not start the new cluster, the old cluster was unmodified =
except that, when linking started, a .old suffix was appended to =
$PGDATA/global/pg_control. To reuse the old cluster, remove the .old =
suffix from $PGDATA/global/pg_control; you can then restart the old =
cluster."
>=20
> I see what you mean.
>=20

There's nothing wrong per se about taking the snapshot before, I was =
just saving the potential time of re-running pg_upgrade. Heck, take a =
snapshot before *and* after ;-)