PostgreSQL has been providing reliable service for our web hosting company since 1997. Thanks!
Last night we got the following error during a dump of an 8.0.6 database: pg_dump: SQL command failed pg_dump: Error message from server: ERROR: could not access status of transaction 245900066 DETAIL: could not open file "/usr/local/pgsql/data/pg_clog/00EA": No such file or directory pg_dump: The command was: SELECT tableoid, oid, oprname, oprnamespace, (select usename from pg_user where oprowner = usesysid) as usename, oprcode::oid as oprcode FROM pg_operator Another dump run during the same time frame did not have this problem, and running the mentioned command in 'psql' produces no error. Research shows that this could be a corrupted tuple, but it's not clear what it means to me if it sometimes work. This follows behavior in the past few days where we noticed PostgreSQL core dumping repeatedly, with this error: PANIC: right sibling's left-link doesn't match The core dumps stopped when we REINDEX'ed the table mentioned in the PANIC statement. We were already planning to upgrade to 8.1.x Real Soon. Are their further insights about this new error? And is my expectation correct that a full/dump restore into 8.1.x would address it? Thanks! Mark . . . . . . . . . . . . . . . . . . . . . . . . . . . Mark Stosberg Principal Developer [EMAIL PROTECTED] Summersault, LLC 765-939-9301 ext 202 database driven websites . . . . . http://www.summersault.com/ . . . . . . . . ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq