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 12:49:37 |
Message-ID: | AM0PR07MB5667C7FCEBE3B00801BDA831A09B0@AM0PR07MB5667.eurprd07.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
I also did a pg_dumpall -s and also no warnings.
I do a pg_dump full backup every week with no incidents.
Versions are:
Windows x64
9.3.22
9.5.15
Thanks for taking a look.
Duarte
De: Duarte Carreira
Enviada: 24 de janeiro de 2019 21:52
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
Hi Tom.
It's 9.5 latest.
I'll try pgdump tomorrow.
Obter o Outlook para Android<https://aka.ms/ghei36>
________________________________
From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us<mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us>>
Sent: Thursday, January 24, 2019 9:02:25 PM
To: Duarte Carreira
Cc: pgsql-general(at)postgresql(dot)org<mailto:pgsql-general(at)postgresql(dot)org>
Subject: Re: duplicate OID issue when using pg_upgrade to move from 9.3 to 9.5
Duarte Carreira <DCarreira(at)edia(dot)pt<mailto:DCarreira(at)edia(dot)pt>> writes:
> I've trying to upgrade a 9.3 instance to 9.5 using pg_upgrade and facing this issue...
9.5.what?
Perusing the commit logs, I note that 9.5.3 included a fix for a
pg_upgrade issue that could possibly lead to this symptom, see
https://git.postgresql.org/gitweb/?p=postgresql.git&a=commitdiff&h=196870f2f
If you are on 9.5.recent, it'd be worth looking closer, because this
is certainly pretty odd. One wouldn't expect a CREATE FUNCTION to
result in assignment of a type OID, at least not in pg_dump/pg_upgrade
scripts --- they should always put out a shell CREATE TYPE first.
By any chance, if you attempt a "pg_dump -s" from the problematic database,
does it emit any warnings (about dependency loops, perhaps)?
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2019-01-25 14:27:41 | Re: duplicate OID issue when using pg_upgrade to move from 9.3 to 9.5 |
Previous Message | Magnus Hagander | 2019-01-25 11:57:39 | Re: Full text search with more than one word |