From: "Wetmore, Matthew (CTR)" <Matthew.Wetmore@express-scripts.com>
To: David Barron <david.barron@zencos.com>,
        "pgsql-admin@lists.postgresql.org"
	<pgsql-admin@lists.postgresql.org>
Subject: RE: upgrade questions
Thread-Topic: upgrade questions
Thread-Index: AdpbeP7Mx96mBzV9TtutqPIoA7X5uwAAXA8Q
Date: Fri, 9 Feb 2024 17:12:21 +0000
Message-ID: <7ba39497463249c78237a2d06ccca2ba@express-scripts.com>
References: 
 <PH0PR22MB33529D6B6891D52EAF8706FCE94B2@PH0PR22MB3352.namprd22.prod.outlook.com>
In-Reply-To: 
 <PH0PR22MB33529D6B6891D52EAF8706FCE94B2@PH0PR22MB3352.namprd22.prod.outlook.com>
Accept-Language: en-US
Content-Language: en-US
Content-Type: multipart/alternative;
	boundary="_000_7ba39497463249c78237a2d06ccca2baexpressscriptscom_"
MIME-Version: 1.0
Archived-At: 
 <https://www.postgresql.org/message-id/7ba39497463249c78237a2d06ccca2ba%40express-scripts.com>
Precedence: bulk

--_000_7ba39497463249c78237a2d06ccca2baexpressscriptscom_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Since you are updating MAJOR versions, this is what I do before that to hav=
e ready, just in case.
(all separate files)

1.      pg_dump -s

2.      pg_dump -a

3.      Pg_dump > *.sql (so human readable)

4.      cp postgresql.conf > wherever

5.      shut down pg and tar the /data dir.

There's more that you can do and this is a little overkill sometimes, but i=
ts easier to delete stuff you don't need after the fact, rather than say , =
darn, I wish I could look at the schema.

And then there's the RHEL layer.
Be able to go back to orig RHEL in need of full rollback.
Save off apt-get stuff (versions etc)


From: David Barron <david.barron@zencos.com>
Sent: Friday, February 9, 2024 9:01 AM
To: pgsql-admin@lists.postgresql.org
Subject: [EXTERNAL] upgrade questions


I'm going to be doing an upgrade from version 11 to version 15 sometime in =
the near future.  I'm a bit nervous about it and I'm hoping I can get some =
questions answered before I take the big step.

First, I'm working on RedHat Linux servers.
Second the existing install is not using the default data directory (/var/l=
ib/pgsql/11/data).  Because of decisions that were made before I got my han=
ds on the servers the data directory is /pgdata-system/11/data.  That's whe=
re the pg_hba.conf and postgresql.conf are located.
Third, 3 tablespaces were created, /pgdata-staging, /pgdata-prod and /pgdat=
a-temp.  I've got the last one setup as the location for temporary files.