Search Postgresql Archives

PostgreSQL 8.3 data corruption

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

2. ERROR: could not access status of transaction 61323662
  Detail: Could not read from file "pg_subtrans/03A7" at offset 188416: No error.

Does anyone know how to resolve the issues above? Would a VACUUM FULL or a dump and restore work? Or is there another way to fix the above.


Thanking you in advance,
Chitra

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux