Re: Improving pg_dump performance

Поиск
Список
Период
Сортировка
От Stephen Frost
Тема Re: Improving pg_dump performance
Дата
Msg-id 20180723134600.GH27724@tamriel.snowman.net
обсуждение исходный текст
Ответ на Re: Improving pg_dump performance  (Ron <ronljohnsonjr@gmail.com>)
Ответы Re: Improving pg_dump performance
Список pgsql-general
Greetings,

* Ron (ronljohnsonjr@gmail.com) wrote:
> An interesting idea.  To clarify: it's possible to parallel backup a running
> 8.4 cluster remotely from a 9.6 system?

Yes, you can do a parallel backup, but you won't be able to get a
consistent snapshot.  You'll need to pause all changes to the database
while the pg_dump processes connect and start their transactions to
have the backup be consistent.

Thanks,

Stephen

Вложения

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

Предыдущее
От: Ron
Дата:
Сообщение: Re: Improving pg_dump performance
Следующее
От: Ron
Дата:
Сообщение: Re: Improving pg_dump performance