Re: [GENERAL] PostgreSQL 8.3 data corruption

2012-05-01 Thread Pavel Stehule
Hello 2012/5/2 Chitra Creta : > Hello all, > > Any thoughts on this one? > if you can use buckup. If you can't then you have to delete broken rows or broken pages and later rebuild all indexes see http://blog.endpoint.com/2010/06/tracking-down-database-corruption-with.html Regards Pavel Stehul

Re: [GENERAL] PostgreSQL 8.3 data corruption

2012-05-01 Thread Chitra Creta
Hello all, Any thoughts on this one? Cheers. On Tue, May 1, 2012 at 9:51 PM, Chitra Creta wrote: > Hi there, > > I have mission-critical data running on PostgreSQL 8.3. My database got > corrupted a few days ago as I ran out of disk space. > > I had to run pg_resetxlog to get the database sta

[GENERAL] PostgreSQL 8.3 data corruption

2012-05-01 Thread Chitra Creta
Hi there, I have mission-critical data running on PostgreSQL 8.3. My database got corrupted a few days ago as I ran out of disk space. I had to run pg_resetxlog to get the database started again. I am now experiencing the following errors: 1. ERROR: t_xmin is uncommitted in tuple to be updated