On Sun, May 31, 2020 at 02:02:08PM -0700, Adrian Klaver wrote:
> 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
This is saying you can only use pg_upgrade 11.X to upgrade _to_ Postgres
11.X. If you want to upgrade to 12, you have to use pg_upgrade from 12.
--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EnterpriseDB https://enterprisedb.com
The usefulness of a cup is in its emptiness, Bruce Lee