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@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 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@xxxxxxxxxx> https://momjian.us EnterpriseDB https://enterprisedb.com The usefulness of a cup is in its emptiness, Bruce Lee
