Re: Improving pg_dump performance - Mailing list pgsql-general

From Ron
Subject Re: Improving pg_dump performance
Date
Msg-id 392cac51-dcde-e47c-6f54-18885138af60@gmail.com
Whole thread Raw
In response to Re: Improving pg_dump performance  (Andreas Kretschmer <andreas@a-kretschmer.de>)
Responses Re: Improving pg_dump performance  (Andreas Kretschmer <andreas@a-kretschmer.de>)
List pgsql-general
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.


pgsql-general by date:

Previous
From: Yogi S
Date:
Subject: copyManager Implementation :: in postgreSQL community Driver
Next
From: Adrian Klaver
Date:
Subject: Re: copyManager Implementation :: in postgreSQL community Driver