Re: Reset oid , starting value=1 - Mailing list pgsql-general

From Gellert, Andre
Subject Re: Reset oid , starting value=1
Date
Msg-id 2740724BDE77EC4CB3CF41EA2227845730AE88@NT-VISEXCH
Whole thread Raw
In response to Reset oid , starting value=1  ("Gellert, Andre" <AGellert@ElectronicPartner.de>)
List pgsql-general
Hi Martijn,

> > There must be a global value which sets the last oid, i need to set this
to
> > "1" or to fill up from 1 , so i have no oids >= 2147483647 for the near
> > future.. how can i do this ? Fixing the mentioned above will take more
time.
>
> The only way to reset oids is to destroy the entire data directory and
> initdb again. In recent versions you can create tables
> without oids, thus
> reducing their usage.

So pg_dump all databases, initdb and playback ? This means a offline-time
for my
systems. Do i need to backup template1 , too ?

> Hope this helps,

To be honest :-) : Not what i was hoping for ...

thx, Andre

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Reset oid , starting value=1
Next
From: Chris Travers
Date:
Subject: Re: CREATE RULE problem/question requesting workaround