Re: [ADMIN] Database is in recovery mode.

2011-11-28 Thread Scott Marlowe
On Mon, Nov 28, 2011 at 10: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

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 `postgres.exe'

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 FAT

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 generally

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

2011-11-28 Thread Tom Lane
David Schnur 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 this here, which se

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 "C:\Users

[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 ther

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 v

Re: [ADMIN] Sequence "self" change - possible?

2011-11-28 Thread Szymon Guz
On 28 November 2011 15:04, 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. > > -- > Łuka

[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