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