Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id E73AB9FB223 for ; Fri, 2 Feb 2007 18:25:43 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 57991-06 for ; Fri, 2 Feb 2007 18:25:39 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id AE9D79FAC76 for ; Fri, 2 Feb 2007 18:25:39 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from out4.smtp.messagingengine.com (out4.smtp.messagingengine.com [66.111.4.28]) by svr4.postgresql.org (Postfix) with ESMTP id BD3095AF03F for ; Fri, 2 Feb 2007 22:25:38 +0000 (GMT) Received: from out1.internal (unknown [10.202.2.149]) by out1.messagingengine.com (Postfix) with ESMTP id 10DB79D46D for ; Fri, 2 Feb 2007 17:25:24 -0500 (EST) Received: from web4.messagingengine.com ([10.202.2.213]) by out1.internal (MEProxy); Fri, 02 Feb 2007 17:25:24 -0500 Received: by web4.messagingengine.com (Postfix, from userid 99) id E4617179083; Fri, 2 Feb 2007 17:25:23 -0500 (EST) Message-Id: <1170455123.6719.1172656201@webmail.messagingengine.com> X-Sasl-Enc: b6IJWcGR5TCsn2n22JgKVLu2HiJ0mgzvR2Z/YyNjEEZ+ 1170455123 From: "Robert Leftwich" To: pgsql-admin@postgresql.org Content-Disposition: inline Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset="ISO-8859-1" MIME-Version: 1.0 X-Mailer: MessagingEngine.com Webmail Interface Subject: pg_dumpall failure - could not access status of transaction Date: Sat, 03 Feb 2007 09:25:23 +1100 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200702/32 X-Sequence-Number: 24497 I am attempting to get a handle on the corruption that caused the following error: pg_dump: SQL command failed pg_dump: Error message from server: ERROR: could not access status of transaction 3183024 DETAIL: could not open file "pg_clog/0003": No such file or directory pg_dump: The command was: SELECT description, classoid, objoid, objsubid FROM pg_catalog.pg_description ORDER BY classoid, objoid, objsubid I've run pg_filedump on all the files with the name = oid from: select oid,relname from pg_class where relname='pg_description'; oid | relname ------+---------------------------- 2609 | pg_description but there are no errors reported. I'm (obviously) lost here - what is the correct way to track down the appropriate file and record to point pg_filedump at to view any corruption? Robert