From: Wetmore, Matthew (CTR) <Matthew.Wetmore@express-scripts.com>
To: David Barron <david.barron@zencos.com>
To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: RE: upgrade questions
Date: Fri, 9 Feb 2024 17:12:21 +0000
Message-ID: <7ba39497463249c78237a2d06ccca2ba@express-scripts.com> (raw)
In-Reply-To: <PH0PR22MB33529D6B6891D52EAF8706FCE94B2@PH0PR22MB3352.namprd22.prod.outlook.com>
References: <PH0PR22MB33529D6B6891D52EAF8706FCE94B2@PH0PR22MB3352.namprd22.prod.outlook.com>
Since you are updating MAJOR versions, this is what I do before that to have 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 its 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/lib/pgsql/11/data). Because of decisions that were made before I got my hands on the servers the data directory is /pgdata-system/11/data. That's where the pg_hba.conf and postgresql.conf are located.
Third, 3 tablespaces were created, /pgdata-staging, /pgdata-prod and /pgdata-temp. I've got the last one setup as the location for temporary files.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: Matthew.Wetmore@express-scripts.com, david.barron@zencos.com, pgsql-admin@lists.postgresql.org
Subject: RE: upgrade questions
In-Reply-To: <7ba39497463249c78237a2d06ccca2ba@express-scripts.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox