Re: Improving pg_dump performance

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, or use an other server in the 
same DC.


Regards, Andreas

-- 
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com