Re: Improving pg_dump performance

Поиск
Список
Период
Сортировка
От Ron
Тема Re: Improving pg_dump performance
Дата
Msg-id 0d0f7d59-19c5-e246-3c5b-0cad8c73cc9d@gmail.com
обсуждение исходный текст
Ответ на Re: Improving pg_dump performance  (Andreas Kretschmer <andreas@a-kretschmer.de>)
Ответы Re: Improving pg_dump performance
Список pgsql-general
On 07/23/2018 08:27 AM, Andreas Kretschmer wrote:
>
> Am 23.07.2018 um 15:06 schrieb Ron:
>> 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.
>>
>
> install the 9.6 also on the old server, 

Are there 9.6 packages for RHEL 5.10?

> or use an other server in the same DC.

An interesting idea.  To clarify: it's possible to parallel backup a running 
8.4 cluster remotely from a 9.6 system?

-- 
Angular momentum makes the world go 'round.


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

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