Re: Improving pg_dump performance

Поиск
Список
Период
Сортировка
От Ron
Тема Re: Improving pg_dump performance
Дата
Msg-id 173ce3e6-2b4f-75fe-25fb-dfafe49d4c6f@gmail.com
обсуждение исходный текст
Ответ на Re: Improving pg_dump performance  (Andres Freund <andres@anarazel.de>)
Ответы Re: Improving pg_dump performance  (Andres Freund <andres@anarazel.de>)
Список pgsql-general
On 07/23/2018 09:11 AM, Andres Freund wrote:
> Hi,
>
> On 2018-07-23 02:23:45 -0500, Ron wrote:
>> 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.
> Have you considered using pg_upgrade instead?

Yes, but:
1. can't find 9.6 packages on the RHEL 5.10 server.
2. The window is only 8 hours, and the data also has to be moved to a new DC 
in that window.

-- 
Angular momentum makes the world go 'round.


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

Предыдущее
От: Ron
Дата:
Сообщение: Re: Improving pg_dump performance
Следующее
От: Sandy Becker
Дата:
Сообщение: Connections on cluster not being logged