On 5/31/20 1:38 PM, Christophe Pettus wrote:
On May 31, 2020, at 13:37, Adrian Klaver <adrian.klaver@xxxxxxxxxxx> wrote:
Just a reminder that the OP's original issue was with using pg_upgrade.
True, although IIRC pg_ugprade uses pg_dump under the hood to do the schema migration.
Again true, but pg_upgrade will not work older to newer:
/usr/local/pgsql11/bin/pg_upgrade --check -U postgres -d
/usr/local/pgsql11/data -D /usr/local/pgsql12_up/data -b
/usr/local/pgsql11/bin -B /usr/local/pgsql12/bin
Performing Consistency Checks
-----------------------------
Checking cluster versions
This utility can only upgrade to PostgreSQL version 11.
Failure, exiting
--
-- Christophe Pettus
xof@xxxxxxxxxxxx
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
