Re: Secuence not updated

Поиск
Список
Период
Сортировка
От Jesus Sandoval
Тема Re: Secuence not updated
Дата
Msg-id 3BF83DBD.F252CC90@mzt.megared.net.mx
обсуждение исходный текст
Ответ на Are WALs affected by 'duplicate key' errors?  ("Jeff Boes" <jboes@nexcerpt.com>)
Список pgsql-admin
Tom Lane escribió:

> Jesus Sandoval <meli@mzt.megared.net.mx> writes:
> > maybe the problem was becase somebody reset the computer without doing a
> > shutdown.
>
> Is that speculation, or do you know that someone actually did that shortly
> before you noticed the problem?
>

That is speculation, I had no control of the computer and somebody could do
that besides the computer had no UPS that week, if you wish I can see the
logs and make sure if I can see some proof of that.

>
> I seem to recall one other report of a sequence apparently losing a few
> counts during a crash, so we may have something to look into here.  But
> we need the clearest description you can give us of the events you
> observed.
>
>                         regards, tom lane


В списке pgsql-admin по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Secuence not updated
Следующее
От: Manuel Trujillo
Дата:
Сообщение: grant access