Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 44B159F9386 for ; Mon, 18 Dec 2006 14:04:45 -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 72159-05 for ; Mon, 18 Dec 2006 14:04:34 -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.168]) by postgresql.org (Postfix) with ESMTP id E82579F9EED for ; Mon, 18 Dec 2006 14:04:34 -0400 (AST) Received: by ug-out-1314.google.com with SMTP id k3so1530055ugf for ; Mon, 18 Dec 2006 10:04:33 -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:in-reply-to:mime-version:content-type:references:x-google-sender-auth; b=SwQfOze40d0K1VBxVDJ7gG71nIlTD+dnpyVE+VakVNuymkDO+5COh//5VbAlAhYvoyRT1rwGw4BLu/2OpBDHqIcmHGk4CdIyMyU4hu/Q09qVDi2bxpLVIOo4Gly7BlkwsiQ1/PoitKFamRyYBxZ8RosinQlX1MAUARD9/60qy98= Received: by 10.67.22.14 with SMTP id z14mr5448722ugi.1166465073502; Mon, 18 Dec 2006 10:04:33 -0800 (PST) Received: by 10.66.245.7 with HTTP; Mon, 18 Dec 2006 10:04:33 -0800 (PST) Message-ID: <2c5b22d10612181004o7a6e45f9n463ccf6b95121391@mail.gmail.com> Date: Mon, 18 Dec 2006 19:04:33 +0100 From: "Edoardo Ceccarelli" To: pgsql-admin@postgresql.org Subject: Re: pg_clog In-Reply-To: <2c5b22d10612180957s78fa6fd8s9f913673bfadbe0e@mail.gmail.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_23491_30512382.1166465073334" References: <2c5b22d10612180957s78fa6fd8s9f913673bfadbe0e@mail.gmail.com> X-Google-Sender-Auth: 562a8468c9274a1d X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/249 X-Sequence-Number: 24041 ------=_Part_23491_30512382.1166465073334 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline sorry, forgot to mention: PG 8.1.5 On 12/18/06, Edoardo Ceccarelli wrote: > > 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_23491_30512382.1166465073334 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline sorry, forgot to mention: PG 8.1.5

On 12/18/06, Edoardo Ceccarelli <eddy@axa.it> wrote:
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_23491_30512382.1166465073334--