We had a crash of one of our db systems last night. After doing a fsck of he file system and getting the db backup, we’re getting a lot of these messages in our logs. The DB will also occasionally crash now.
Oct 12 07:40:16 postgres[30770]: [3-1] 2007-10-12 07:40:16 PDTERROR: could not access status of transaction 2259991368
Oct 12 07:40:16 postgres[30770]: [3-2] 2007-10-12 07:40:16 PDTDETAIL: Could not read from file "pg_clog/086B" at offset 73728: Success.
Any ideas?
Thanks,
Akash