Re: pg_dump restore as transaction?

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: pg_dump restore as transaction?
Дата
Msg-id 20081201174002.GG4459@alvh.no-ip.org
обсуждение исходный текст
Ответ на pg_dump restore as transaction?  (Owen Hartnett <owen@clipboardinc.com>)
Список pgsql-general
Owen Hartnett wrote:

> If my perusal of the sql generated by pg_dump is correct, then it
> doesn't appear that it's wrapped in a transaction, and thus might be
> able to only complete a partial restore?

You're right, it is not.  Try pg_restore --single-transaction.  (You'll
need pg_dump -Fc though.)


--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: pg_dump restore as transaction?
Следующее
От: Peter Billen
Дата:
Сообщение: Re: pg_dump restore as transaction?