OIDs depending data -- how to dump/restore?

From: "fkater(at)googlemail(dot)com" <fkater(at)googlemail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: OIDs depending data -- how to dump/restore?
Date: 2010-03-14 16:21:06
Message-ID: 20100314162106.GA2153@comppasch2
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,

I have several databases here which I would like to update
from 8.2 to 8.4, which in turn requires a dump/restore.

However, the databases are OIDs depending, so, some values
depend on OIDs in other tables.

AFAIK the dump/restore does not rebuild the original OID
values, so all relations built accross OIDs fail.

(1)
Is there a way to keep the original OID values somehow?

(2)
If I need to go the long way and replace the OIDs with
SERIALs first, updating all relations to it etc: Would a
dump/restore then restore the original values in a SERIAL
column?

Thank You
Felix

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Raymond O'Donnell 2010-03-14 16:40:51 Re: OIDs depending data -- how to dump/restore?
Previous Message Alvaro Herrera 2010-03-14 14:43:21 Re: unexplained autovacuum to prevent wraparound