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 по дате отправления: