On 2/11/20 5:43 AM, Rich Shepard wrote:
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.
The above runs the psql client not the server. It is a way of
determining what version binaries /usr/lib64/postgresql/11/bin/
actually contains.
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
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
