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