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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Duarte Carreira <DCarreira(at)edia(dot)pt>
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 14:27:41
Message-ID: 25393.1548426461@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next 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
Previous Message Duarte Carreira 2019-01-25 12:49:37 RE: duplicate OID issue when using pg_upgrade to move from 9.3 to 9.5