Re: Secuence not updated

From: Jesus Sandoval <meli(at)mzt(dot)megared(dot)net(dot)mx>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Secuence not updated
Date: 2001-11-18 23:01:18
Message-ID: 3BF83DBD.F252CC90@mzt.megared.net.mx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Tom Lane escribió:

> Jesus Sandoval <meli(at)mzt(dot)megared(dot)net(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Manuel Trujillo 2001-11-19 12:03:33 grant access
Previous Message Tom Lane 2001-11-18 19:59:29 Re: Secuence not updated