Re: Improving pg_dump performance

Поиск
Список
Период
Сортировка
От Ron
Тема Re: Improving pg_dump performance
Дата
Msg-id 392cac51-dcde-e47c-6f54-18885138af60@gmail.com
обсуждение исходный текст
Ответ на Re: Improving pg_dump performance  (Andreas Kretschmer <andreas@a-kretschmer.de>)
Ответы Re: Improving pg_dump performance
Список pgsql-general
On 07/23/2018 02:32 AM, Andreas Kretschmer wrote:
>
>
> Am 23.07.2018 um 09:23 schrieb Ron:
>> Hi,
>>
>> We've got an old (v8.4.17, thus no parallel backups) 2.9TB database that 
>> needs to be migrated to a new data center and then restored to v9.6.9. 
>
> you can use the pg_dump from the newer version (9.6) to dump the old 
> database, over the net. In this way you can also use parallel backups 
> (directory format)

That DC circuit is too slow, and also used by lots of other production data.

-- 
Angular momentum makes the world go 'round.


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

Предыдущее
От: Yogi S
Дата:
Сообщение: copyManager Implementation :: in postgreSQL community Driver
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: copyManager Implementation :: in postgreSQL community Driver