RE: upgrade questions - Mailing list pgsql-admin

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)

Yes, I had assumed I would be doing backups.