From: | Duarte Carreira <DCarreira(at)edia(dot)pt> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | RE: duplicate OID issue when using pg_upgrade to move from 9.3 to 9.5 |
Date: | 2019-01-25 15:16:57 |
Message-ID: | AM0PR07MB5667AC4ECD1FF8E8E54E47DCA09B0@AM0PR07MB5667.eurprd07.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
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(at)sss(dot)pgh(dot)pa(dot)us>
Enviada: 25 de janeiro de 2019 14:28
Para: Duarte Carreira <DCarreira(at)edia(dot)pt>
Cc: pgsql-general(at)postgresql(dot)org
Assunto: Re: duplicate OID issue when using pg_upgrade to move from 9.3 to 9.5
Duarte Carreira <DCarreira(at)edia(dot)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
Attachment | Content-Type | Size |
---|---|---|
dump_schema_db_postgis.custom | application/octet-stream | 9.8 MB |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2019-01-25 16:04:01 | Re: duplicate OID issue when using pg_upgrade to move from 9.3 to 9.5 |
Previous Message | Duarte Carreira | 2019-01-25 15:00:51 | RE: duplicate OID issue when using pg_upgrade to move from 9.3 to 9.5 |