Re: Reset oid , starting value=1

Поиск
Список
Период
Сортировка
От Gellert, Andre
Тема Re: Reset oid , starting value=1
Дата
Msg-id 2740724BDE77EC4CB3CF41EA2227845730AE88@NT-VISEXCH
обсуждение исходный текст
Ответ на Reset oid , starting value=1  ("Gellert, Andre" <AGellert@ElectronicPartner.de>)
Список 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 по дате отправления:

Предыдущее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: Reset oid , starting value=1
Следующее
От: Chris Travers
Дата:
Сообщение: Re: CREATE RULE problem/question requesting workaround