Re: Pre-version pg_upgrade syntax check

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