[ADMIN] Sequence self change - possible?

2011-11-28 Thread Lukasz Brodziak
Hello, Is it possible for sequence to decrement its value by itself? Or is it possible to see wether it was changed by someone. The thing is that on one of our clinet's DB sequence rolled back to the state from 8 months ago. -- Łukasz Brodziak

Re: [ADMIN] Sequence self change - possible?

2011-11-28 Thread Szymon Guz
On 28 November 2011 15:04, Lukasz Brodziak lukasz.brodz...@gmail.comwrote: Hello, Is it possible for sequence to decrement its value by itself? Or is it possible to see wether it was changed by someone. The thing is that on one of our clinet's DB sequence rolled back to the state from 8

Re: [ADMIN] Sequence self change - possible?

2011-11-28 Thread Oliveiros d'Azevedo Cristina
Can it be that it wrapped around? Best, Oliveiros - Original Message - From: Lukasz Brodziak To: pgsql-admin@postgresql.org Sent: Monday, November 28, 2011 2:04 PM Subject: [ADMIN] Sequence self change - possible? Hello, Is it possible for sequence to decrement its

[ADMIN] Database is in recovery mode.

2011-11-28 Thread Lukasz Brodziak
Hello, I have a problem with client's database. When I log into application and work on the data everything seems fine, but when I try to dumpd the database connection closes. I have located the faulty table and when I try to cluster it I get FATAL: database is in recovery mode. It seems that

Re: [ADMIN] Repeatable crash in pg_dump (with -d2 info)

2011-11-28 Thread David Schnur
I probably can't get a stack trace, but I was able to reproduce it with just that function. Without the function, pg_dump works fine. I can DROP the function, pg_dump works, then add it back again and pg_dump crashes. Here are my steps: initdb -A md5 --no-locale -E UTF8 -U testuser -D

Re: [ADMIN] Repeatable crash in pg_dump (with -d2 info)

2011-11-28 Thread Tom Lane
David Schnur dnsch...@gmail.com writes: I probably can't get a stack trace, but I was able to reproduce it with just that function. Without the function, pg_dump works fine. I can DROP the function, pg_dump works, then add it back again and pg_dump crashes. Hmph. I still can't reproduce

Re: [ADMIN] Sequence self change - possible?

2011-11-28 Thread Craig Ringer
On 11/28/2011 10:04 PM, Lukasz Brodziak wrote: Hello, Is it possible for sequence to decrement its value by itself? Or is it possible to see wether it was changed by someone. The thing is that on one of our clinet's DB sequence rolled back to the state from 8 months ago. It shouldn't

Re: [ADMIN] Database is in recovery mode.

2011-11-28 Thread Craig Ringer
On 11/29/2011 01:11 AM, Lukasz Brodziak wrote: Hello, I have a problem with client's database. When I log into application and work on the data everything seems fine, but when I try to dumpd the database connection closes. I have located the faulty table and when I try to cluster it I get

Re: [ADMIN] Repeatable crash in pg_dump (with -d2 info)

2011-11-28 Thread Craig Ringer
On 11/29/2011 06:20 AM, David Schnur wrote: I probably can't get a stack trace Getting a usable stack trace on Windows isn't actually too hard. See: http://wiki.postgresql.org/wiki/Getting_a_stack_trace_of_a_running_PostgreSQL_backend_on_Windows That's focused on debugging the

Re: [ADMIN] Database is in recovery mode.

2011-11-28 Thread Scott Marlowe
On Mon, Nov 28, 2011 at 10:11 AM, Lukasz Brodziak lukasz.brodz...@gmail.com wrote: Hello, I have a problem with client's database. When I log into application and work on the data everything seems fine, but when I try to dumpd the database connection closes. I have located the faulty table and