RE: duplicate OID issue when using pg_upgrade to move from 9.3 to 9.5

[Duarte Carreira <DCarreira@xxxxxxx>]

Tom,

Used this command to dump the file attached:
"D:\Program Files\PostgreSQL\9.5\bin\pg_dump.exe" -Fc -p 5432 -U postgres -W -s postgis >dump_schema_db_postgis.custom

Hope you're able to pinpoint the issue.

Thanks again.
Duarte

-----Mensagem original-----
De: Duarte Carreira 
Enviada: 25 de janeiro de 2019 15:01
Para: 'Tom Lane' <tgl@xxxxxxxxxxxxx>
Cc: pgsql-general@xxxxxxxxxxxxxx
Assunto: RE: duplicate OID issue when using pg_upgrade to move from 9.3 to 9.5

Sure, I'll be sending you the dump shortly off-list.

Duarte

-----Mensagem original-----
De: Tom Lane <tgl@xxxxxxxxxxxxx> 
Enviada: 25 de janeiro de 2019 14:28
Para: Duarte Carreira <DCarreira@xxxxxxx>
Cc: pgsql-general@xxxxxxxxxxxxxx
Assunto: Re: duplicate OID issue when using pg_upgrade to move from 9.3 to 9.5

Duarte Carreira <DCarreira@xxxxxxx> 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

Attachment: dump_schema_db_postgis.custom
Description: dump_schema_db_postgis.custom