Re: Improving pg_dump performance

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.