Re: [GENERAL] database corruption

2009-04-08 Thread Jeff Brenton
There are 9 miilion inodes free on /db. All other partitions have at least 1/2 million free. -Original Message- From: Joshua D. Drake [mailto:j...@commandprompt.com] Sent: Wednesday, April 08, 2009 10:26 PM To: Jeff Brenton Cc: Adrian Klaver; pgsql-general@postgresql.org Subject: Re

Re: [GENERAL] database corruption

2009-04-08 Thread Jeff Brenton
il 08, 2009 10:08 PM To: Jeff Brenton Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] database corruption I would imagine you would have better luck dropping the index and recreating. But considering you're 98% full on that drive, it looks like you're about to have other problem

Re: [GENERAL] database corruption

2009-04-08 Thread Jeff Brenton
config files but can't seem to find anything which leads me to believe that its part of the postgres data directory. -Original Message- From: Adrian Klaver [mailto:akla...@comcast.net] Sent: Wednesday, April 08, 2009 10:10 PM To: pgsql-general@postgresql.org Cc: Jeff Brenton Subjec

[GENERAL] database corruption

2009-04-08 Thread Jeff Brenton
I've encountered some db corruption after restarting postgres on my database server running 8.2.4. I think that postgres did not shut down cleanly. Postgres started appropriately but crashed 45 minutes later. I used pg_resetxlog after the crash to get the db to start again but it appears that the