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 pg_dump: La commande SQL de sauvegarde du contenu de la table "facture" a échoué : échec de PQendcopy(). pg_dump: Message d'erreur du serveur : 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 pg_dump: La commande était : COPY public.facture ([...]) TO stdout; -------8<------------8<-----------8<----------- It say that it cant access to the transaction id 892415538 because the file /var/lib/postgresql/7.4/main/pg_clog/0353 dont exist. And this file doesn't exist. I use PG 7.4.16 on linux debian etch. I already made a HD & memory test, and i find nothing wrong. Last time i got this error, the only solution was to get a "safe" backup and lost some data. But i didnt have time to manage this server, so this error is here for a couple of day, and im afraid about how many data may be lost. So if someone have an idea to have a "safe" backup and start on a clean database... Thx in advance, Regards,
