Re: Problem with a transaction on dump

Alvaro Herrera wrote:
>
> Froggy / Froggy Corp. wrote:
> > Hello everyone,
> >
> > It is the second time i got this error message (sorry, its french, i
> > prefer to c/p this one than making a bad translation) :
> >
> > -------8<------------8<-----------8<-----------
> >
> > pg_dump: ERREUR: Impossible d'accéder au statut de la transaction
> > 892415538
> > DETAIL: Impossible d'ouvrir le fichier
> > «/var/lib/postgresql/7.4/main/pg_clog/0353» : Aucun fichier ou
> > répertoire de ce type
>
> What files are there in main/pg_clog?

0000 to 0024

--------------------8<------------8<----------------8<--------
-rw------- 1 postgres postgres 262144 Jul 25 2006 0000
-rw------- 1 postgres postgres 262144 Jul 28 2006 0001
-rw------- 1 postgres postgres 262144 Aug 5 2006 0002
-rw------- 1 postgres postgres 262144 Aug 13 2006 0003
-rw------- 1 postgres postgres 262144 Aug 22 2006 0004
-rw------- 1 postgres postgres 262144 Aug 28 2006 0005
-rw------- 1 postgres postgres 262144 Sep 4 2006 0006
-rw------- 1 postgres postgres 262144 Sep 10 2006 0007
-rw------- 1 postgres postgres 262144 Sep 17 2006 0008
-rw------- 1 postgres postgres 262144 Sep 25 2006 0009
-rw------- 1 postgres postgres 262144 Oct 2 2006 000A
-rw------- 1 postgres postgres 262144 Oct 9 19:50 000B
-rw------- 1 postgres postgres 262144 Oct 17 06:04 000C
-rw------- 1 postgres postgres 262144 Oct 25 11:13 000D
-rw------- 1 postgres postgres 262144 Nov 2 12:44 000E
-rw------- 1 postgres postgres 262144 Nov 8 21:41 000F
-rw------- 1 postgres postgres 262144 Nov 16 10:03 0010
-rw------- 1 postgres postgres 262144 Nov 23 07:56 0011
-rw------- 1 postgres postgres 262144 Nov 29 22:48 0012
-rw------- 1 postgres postgres 262144 Dec 6 16:36 0013
-rw------- 1 postgres postgres 262144 Dec 13 02:15 0014
-rw------- 1 postgres postgres 262144 Dec 19 15:57 0015
-rw------- 1 postgres postgres 262144 Dec 27 04:34 0016
-rw------- 1 postgres postgres 262144 Jan 2 22:14 0017
-rw------- 1 postgres postgres 262144 Jan 8 17:27 0018
-rw------- 1 postgres postgres 262144 Jan 17 16:02 0019
-rw------- 1 postgres postgres 262144 Jan 24 00:18 001A
-rw------- 1 postgres postgres 262144 Jan 31 10:03 001B
-rw------- 1 postgres postgres 262144 Feb 6 17:23 001C
-rw------- 1 postgres postgres 262144 Feb 13 13:34 001D
-rw------- 1 postgres postgres 262144 Feb 20 22:23 001E
-rw------- 1 postgres postgres 262144 Feb 28 18:03 001F
-rw------- 1 postgres postgres 262144 Mar 8 09:58 0020
-rw------- 1 postgres postgres 262144 Mar 16 15:07 0021
-rw------- 1 postgres postgres 262144 Mar 25 04:02 0022
-rw------- 1 postgres postgres 262144 Apr 2 14:21 0023
-rw------- 1 postgres postgres 81920 Apr 4 16:17 0024
---------8<------------8<--------------8<----------