Restoring Backup With OIDs As Primary Key - Mailing list pgsql-admin

From Ben C
Subject Restoring Backup With OIDs As Primary Key
Date
Msg-id 7DA06115D1591D41A33328B737C1F4122F309E@svrect1.ect.local
Whole thread Raw
Responses Re: Restoring Backup With OIDs As Primary Key  (Andrew Sullivan <ajs@commandprompt.com>)
Re: Restoring Backup With OIDs As Primary Key  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-admin

Hello,

I am trying to restore from a backup db that used oids as primary keys * ... when I do this the max oid value in the new database is around the 1700 mark where as the database I am pulling in is around 20,000,000 . which means any new data added to the dataabse is going to be clobbered.

Is there a way to increment the OID by changing a value in the system tables?

thanks in advance

* at the time this was implemented way back at 7.x, from what I had read it seemed like acceptable practice :/

pgsql-admin by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: Bug introduced in 8.0
Next
From: Andrew Sullivan
Date:
Subject: Re: Restoring Backup With OIDs As Primary Key