Re: Pre-version pg_upgrade syntax check

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@aklaver.com