Re: Secuence not updated - Mailing list pgsql-admin

From Jesus Sandoval
Subject Re: Secuence not updated
Date
Msg-id 3BF83DBD.F252CC90@mzt.megared.net.mx
Whole thread Raw
In response to Are WALs affected by 'duplicate key' errors?  ("Jeff Boes" <jboes@nexcerpt.com>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Secuence not updated
Next
From: Manuel Trujillo
Date:
Subject: grant access