On 5/31/20 1:38 PM, Christophe Pettus wrote:
>
>
>> On May 31, 2020, at 13:37, Adrian Klaver <adrian.klaver@aklaver.com> 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@thebuild.com
>
--
Adrian Klaver
adrian.klaver@aklaver.com