Re: pg_dump restore as transaction?

Поиск
Список
Период
Сортировка
От Peter Billen
Тема Re: pg_dump restore as transaction?
Дата
Msg-id 20081201183624.xh0ae5ygxzwg04go@webmail.clueless.be
обсуждение исходный текст
Ответ на pg_dump restore as transaction?  (Owen Hartnett <owen@clipboardinc.com>)
Список pgsql-general
Quoting Owen Hartnett <owen@clipboardinc.com>:

>
> 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?
>
> Or does
>
> psql myDatabase <mypg_dumpfile
>

Try to use pg_restore with the following option:

  -1, --single-transaction
                           restore as a single transaction

Or psql with the following option:

  -1 ("one")      execute command file as a single transaction

Kind regards,

Peter



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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: pg_dump restore as transaction?
Следующее
От: Owen Hartnett
Дата:
Сообщение: Re: pg_dump restore as transaction?