Re: duplicate OID issue when using pg_upgrade to move from 9.3 to 9.5 - Mailing list pgsql-general

From Tom Lane
Subject Re: duplicate OID issue when using pg_upgrade to move from 9.3 to 9.5
Date
Msg-id 25393.1548426461@sss.pgh.pa.us
Whole thread Raw
In response to RE: duplicate OID issue when using pg_upgrade to move from 9.3 to 9.5  (Duarte Carreira <DCarreira@edia.pt>)
Responses RE: duplicate OID issue when using pg_upgrade to move from 9.3 to 9.5  (Duarte Carreira <DCarreira@edia.pt>)
List pgsql-general
Duarte Carreira <DCarreira@edia.pt> writes:
> Tom, just did a pg_dump -s from 9.3 and there are no warnings in the output file. It goes smoothly and fast (few
seconds).Database is around 50GB, schema 9MB. Has postgis and a few more extensions - ogr_fdw (from postigs), file_fdw,
postgres_fdw,table_func. 

Hmph.  Would you be willing to send me a schema-only dump (off-list!)
of the problematic database?  The best format would be an "-Fc -s"
pg_dump output, because that would show what pg_dump thinks the
dependencies are.  Be sure you make it with the newer pg_dump.

            regards, tom lane


pgsql-general by date:

Previous
From: Duarte Carreira
Date:
Subject: RE: duplicate OID issue when using pg_upgrade to move from 9.3 to 9.5
Next
From: Duarte Carreira
Date:
Subject: RE: duplicate OID issue when using pg_upgrade to move from 9.3 to 9.5