Re: [GENERAL] PostgreSQL 8.3 data corruption

2012-05-02 Thread Chitra Creta
Hello all, Any thoughts on this one? Cheers. On Tue, May 1, 2012 at 9:51 PM, Chitra Creta chitracr...@gmail.com 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

Re: [GENERAL] PostgreSQL 8.3 data corruption

2012-05-02 Thread Pavel Stehule
Hello 2012/5/2 Chitra Creta chitracr...@gmail.com: 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

[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