On Mon, 10 Feb 2020, Adrian Klaver wrote:
So you already have 11 and 12 instances of Postgres running?
Adrian, No. Both 11 and 12 are installed; neither is running. I have a cron job that runs pg_dumpall every weekday night.
If so why use pg_upgrade?
Because I wanted to try it rather than use 'psql -f <filename>.sql'
To verify what is going on do: /usr/lib64/postgresql/11/bin/psql --version
The pg_upgrade page says to not have either the old or new versions running.
vi /var/lib/pgsql/11/data/PG_VERSION
/var/lib/pgsql/11/data/PG_VERSION is 11; /var/lib/pgsql/12/data/PG_VERSION is 12. Rich
