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 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
