Re: Improving pg_dump performance

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.