Thread: pg_dump crashes the backend

pg_dump crashes the backend

From

Louis-David Mitterrand

Date:

14 March 2003, 08:23:11

[7.3.2 on debian unstable]

We recently had an unclean server shutdown and now a pg_dump command
crashes the backend:

pg_dump: PANIC:  open of /var/lib/postgres/data/pg_clog/0003 failed: No
such file or directory

Should we restore from a known good dump after an initdb?

--    PHEDRE: Malheureuse ! Voilà comme tu m'as perdue.           Au jour que je fuyais c'est toi qui m'as rendue.
                                  (Phèdre, J-B Racine, acte 4, scène 6)

Re: pg_dump crashes the backend

From

Tom Lane

Date:

14 March 2003, 15:02:24

Louis-David Mitterrand <vindex@apartia.org> writes:
> [7.3.2 on debian unstable]
> We recently had an unclean server shutdown and now a pg_dump command
> crashes the backend:
> pg_dump: PANIC:  open of /var/lib/postgres/data/pg_clog/0003 failed: No
> such file or directory
> Should we restore from a known good dump after an initdb?

If you have a good dump then initdb and reload seems like the best
answer.  Before you do, though, I'd be interested to see an ls -l of the
pg_clog directory (I'm interested in the names/sizes/mod times of the
files therein).  Can you give any more details about the server
shutdown?
        regards, tom lane