Re: Problem with a transaction on dump - Mailing list pgsql-general

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<----------