Search Postgresql Archives

Re: Pre-version pg_upgrade syntax check

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxx





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux