Re: pg_dump corrupts database?

Поиск
Список
Период
Сортировка
От Dennis Gearon
Тема Re: pg_dump corrupts database?
Дата
Msg-id 3F311B96.5060306@cvc.net
обсуждение исходный текст
Ответ на pg_dump corrupts database?  (Stephen Robert Norris <srn@commsecure.com.au>)
Список 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 по дате отправления:

Предыдущее
От: Justin Tocci
Дата:
Сообщение: Re: INSERT RULE QUERY ORDER
Следующее
От: "Wilson A. Galafassi Jr."
Дата:
Сообщение: Postgresql slow on XEON 2.4ghz/1gb ram