Re: pg_dump corrupts database? - Mailing list pgsql-general

From Dennis Gearon
Subject Re: pg_dump corrupts database?
Date
Msg-id 3F311B96.5060306@cvc.net
Whole thread Raw
In response to pg_dump corrupts database?  (Stephen Robert Norris <srn@commsecure.com.au>)
List pgsql-general
seems like that shouldn't happen.

Stephen Robert Norris wrote:

> I've encountered this a few times with 7.2 and 7.3.
>
> If I do pg_dump of some large (> 100Mb - the bigger the more likely)
> database, and it gets interrupted for some reason (e.g. the target disk
> fills up), the source database become corrupt. I start getting errors
> like:
>
> open of /var/lib/pgsql/data/pg_clog/0323 failed: No such file or
> directory
>
> and I have to drop/restore the table in question.
>
> Is this a known problem? Is there some safe way to dump databases that
> avoids it?
>
>     Stephen


pgsql-general by date:

Previous
From: Justin Tocci
Date:
Subject: Re: INSERT RULE QUERY ORDER
Next
From: "Wilson A. Galafassi Jr."
Date:
Subject: Postgresql slow on XEON 2.4ghz/1gb ram