Postgres Pro
Downloads
Home   >   mailing lists

Re: Pre-version pg_upgrade syntax check - Mailing list pgsql-general

From Rich Shepard
Subject Re: Pre-version pg_upgrade syntax check
Date
Msg-id alpine.LNX.2.20.2002101603250.4839@salmo.appl-ecosys.com
Whole thread Raw
In response to Re: Pre-version pg_upgrade syntax check  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: Pre-version pg_upgrade syntax check
List pgsql-general
Tree view 
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.

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

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Pre-version pg_upgrade syntax check
Next
From: Jerry Sievers
Date:
Subject: Re: Postgres 12.1 : UPPER() in WHERE clause restarts server