Re: Pre-version pg_upgrade syntax check

On 2/10/20 4:07 PM, Rich Shepard wrote:
> On Mon, 10 Feb 2020, Adrian Klaver wrote:
> 
>> What it is saying is -b and -d are pointing at binary and data 
>> directories
>> that are incompatible. You need to make sure that:
>>
>> /usr/lib64/postgresql/11/bin/
>> and
>> /var/lib/pgsql/11/data
>>
>> are actually pointing at 11 instances of binaries and data respectively.
> 
> Adrian,
> 
> I just copied the contents of those directories from last Thursday's
> backups. Still fails.

So you already have 11 and 12 instances of Postgres running?

If so why use pg_upgrade?

To verify what is going on do:

/usr/lib64/postgresql/11/bin/psql --version

vi /var/lib/pgsql/11/data/PG_VERSION

> 
> I have the pg_dumpall .sql file from last Thursday. I'll fire up
> postgresql-12.1 and us pgsql to read in that file, unless you have a
> recommendation for me to apply.
> 
> Thanks,
> 
> Rich
> 
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com