Re: Improving pg_dump performance - Mailing list pgsql-general

From Andreas Kretschmer
Subject Re: Improving pg_dump performance
Date
Msg-id d2b7e68c-799a-bc40-a86f-89accae0a5ca@a-kretschmer.de
Whole thread Raw
In response to Re: Improving pg_dump performance  (Ron <ronljohnsonjr@gmail.com>)
Responses Re: Improving pg_dump performance  (Ron <ronljohnsonjr@gmail.com>)
List pgsql-general

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



pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: copyManager Implementation :: in postgreSQL community Driver
Next
From: Stephen Frost
Date:
Subject: Re: Improving pg_dump performance