Re: Reset oid , starting value=1

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