From: Wetmore, Matthew (CTR) <Matthew.Wetmore@express-scripts.com> Sent: Friday, February 9, 2024 12:12 PM To: David Barron <david.barron@zencos.com>; pgsql-admin@lists.postgresql.org Subject: RE: upgrade questions
EXTERNAL SENDER
Since you are updating MAJOR versions, this is what I do before that to have ready, just in case.
(all separate files)
pg_dump –s
pg_dump –a
Pg_dump > *.sql (so human readable)
cp postgresql.conf > wherever
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.