Re: Improving pg_dump performance

Поиск
Список
Период
Сортировка
Искать
От
Andreas Kretschmer
Тема
Re: Improving pg_dump performance
Дата
Msg-id
afa64b21-b9ba-4a0e-2c6b-5a7f7d3e5bb7@a-kretschmer.de
Ответ на
Improving pg_dump performance (Ron)
Список
Дерево обсуждения
Improving pg_dump performance Ron <ronljohnsonjr@gmail.com>
Re: Improving pg_dump performance Stephen Frost <sfrost@snowman.net>
Re: Improving pg_dump performance Andres Freund <andres@anarazel.de>
Re: Improving pg_dump performance Ron <ronljohnsonjr@gmail.com>
Re: Improving pg_dump performance Andres Freund <andres@anarazel.de>
Re: Improving pg_dump performance Andreas Kretschmer <andreas@a-kretschmer.de>
Re: Improving pg_dump performance Ron <ronljohnsonjr@gmail.com>
Re: Improving pg_dump performance Andreas Kretschmer <andreas@a-kretschmer.de>
Re: Improving pg_dump performance Ron <ronljohnsonjr@gmail.com>
Re: Improving pg_dump performance Stephen Frost <sfrost@snowman.net>
Re: Improving pg_dump performance Ron <ronljohnsonjr@gmail.com>
Re: Improving pg_dump performance Adrian Klaver <adrian.klaver@aklaver.com>
Re: Improving pg_dump performance Ron <ronljohnsonjr@gmail.com>
RE: Improving pg_dump performance Kevin Brannen <KBrannen@efji.com>
Re: Improving pg_dump performance Adrian Klaver <adrian.klaver@aklaver.com> 


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)


Regards, Andreas

-- 
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com
В списке pgsql-general по дате отправления
Предыдущее
От: Ron
Дата:
Сообщение: Improving pg_dump performance
Следующее
От: Yogi S
Дата:
FAQ