Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 83D8F9F9FE1 for ; Mon, 18 Dec 2006 14:09:34 -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 78159-05 for ; Mon, 18 Dec 2006 14:09:25 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from wx-out-0506.google.com (wx-out-0506.google.com [66.249.82.228]) by postgresql.org (Postfix) with ESMTP id D10169F9F46 for ; Mon, 18 Dec 2006 14:09:26 -0400 (AST) Received: by wx-out-0506.google.com with SMTP id i28so1467731wxd for ; Mon, 18 Dec 2006 10:09:26 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=DD1Vab9aBVff+UOZScvQWMrbmAsOu1v0WvoeSAjRFv8eX7DtByj+uNhR8VZHtNQowRt7d+fUHWx0LANZ3bqsc8/Z51GLBjtOeiCyTKWOHxkBFZf5iGmGSmMtaxM/n6F6zLHBv1sBypMkJuk9y0NHdZlBgMoUSqBOrqVUStjPZEI= Received: by 10.90.113.18 with SMTP id l18mr3925863agc.1166465365990; Mon, 18 Dec 2006 10:09:25 -0800 (PST) Received: by 10.65.206.17 with HTTP; Mon, 18 Dec 2006 10:09:25 -0800 (PST) Message-ID: Date: Mon, 18 Dec 2006 23:09:25 +0500 From: "Shoaib Mir" To: "Edoardo Ceccarelli" Subject: Re: pg_clog Cc: pgsql-admin@postgresql.org In-Reply-To: <2c5b22d10612180957s78fa6fd8s9f913673bfadbe0e@mail.gmail.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_13584_33544905.1166465365474" References: <2c5b22d10612180957s78fa6fd8s9f913673bfadbe0e@mail.gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/250 X-Sequence-Number: 24042 ------=_Part_13584_33544905.1166465365474 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline You can try creating the missing clog file as 256K of zeros, once that is done you can now try going through the pg_dump process again. This suggestion might help you as well --> http://archives.postgresql.org/pgsql-admin/2003-02/msg00263.php --------------------- Shoaib Mir EnterpriseDB (www.enterprisedb.com) 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_13584_33544905.1166465365474 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline You can try creating the missing clog file as 256K of zeros, once that is done you can now try going through the pg_dump process again.

This suggestion might help you as well --> http://archives.postgresql.org/pgsql-admin/2003-02/msg00263.php

---------------------
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)

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_13584_33544905.1166465365474--