Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id F29889FA339 for ; Mon, 18 Dec 2006 13:57:38 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 65219-03 for ; Mon, 18 Dec 2006 13:57:24 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.172]) by postgresql.org (Postfix) with ESMTP id 83EEA9F9357 for ; Mon, 18 Dec 2006 13:57:24 -0400 (AST) Received: by ug-out-1314.google.com with SMTP id k3so1528345ugf for ; Mon, 18 Dec 2006 09:57:24 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:sender:to:subject:mime-version:content-type:x-google-sender-auth; b=XiVOZ9C6r/YK6il172hS9K+liv5U7IuB4ricVLWqoegaqtYGQHWzWsqYTrEKAHXNjDxgFr7xOBBYTC6ARqXG1ZOVJPBnG4WMuW7Nx1bBADREkp/fd5JRrXbNX7wmY8YLLrBH5/tqz9WRGz/9Ly14Jv6CojA8VG5NNNBvad2GdUU= Received: by 10.67.19.13 with SMTP id w13mr5546012ugi.1166464643811; Mon, 18 Dec 2006 09:57:23 -0800 (PST) Received: by 10.66.245.7 with HTTP; Mon, 18 Dec 2006 09:57:23 -0800 (PST) Message-ID: <2c5b22d10612180957s78fa6fd8s9f913673bfadbe0e@mail.gmail.com> Date: Mon, 18 Dec 2006 18:57:23 +0100 From: "Edoardo Ceccarelli" To: pgsql-admin@postgresql.org Subject: pg_clog MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_23335_5372501.1166464643643" X-Google-Sender-Auth: a387e54bd01598c0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/248 X-Sequence-Number: 24040 ------=_Part_23335_5372501.1166464643643 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Hi, just encountered this error trying to dump my db: any ideas? Thank you pg_dump: ERROR: could not access status of transaction 1629514106 DETAIL: could not open file "pg_clog/0612": No such file or directory pg_dump: SQL command to dump the contents of table "annuncio400" failed: PQendcopy() failed. pg_dump: Error message from server: ERROR: could not access status of transaction 1629514106 DETAIL: could not open file "pg_clog/0612": No such file or directory pg_dump: The command was: COPY public.annuncio400 (testo, telef1, pref1, rubric, tiprec, uscita, telef2, pref2, giornouscita, meseuscita, annouscita, prezzo, annofabbr, locali, codedi, codcliente, email, tipoannuncio, ka) TO stdout; ------=_Part_23335_5372501.1166464643643 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Hi,

just encountered this error trying to dump my db:
any ideas?

Thank you


pg_dump: ERROR:  could not access status of transaction 1629514106

DETAIL:  could not open file "pg_clog/0612": No such file or directory

pg_dump: SQL command to dump the contents of table "annuncio400" failed: PQendcopy() failed.

pg_dump: Error message from server: ERROR:  could not access status of transaction 1629514106

DETAIL:  could not open file "pg_clog/0612": No such file or directory

pg_dump: The command was: COPY public.annuncio400 (testo, telef1, pref1, rubric, tiprec, uscita, telef2, pref2, giornouscita, meseuscita, annouscita, prezzo, annofabbr, locali, codedi, codcliente, email, tipoannuncio, ka) TO stdout;

------=_Part_23335_5372501.1166464643643--