Re: pg_dump of database with numerous objects

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

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com