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
