Re: Improving pg_dump performance

From: Ron <ronljohnsonjr(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Improving pg_dump performance
Date: 2018-07-23 13:06:28
Message-ID: 392cac51-dcde-e47c-6f54-18885138af60@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2018-07-23 13:24:40 Re: copyManager Implementation :: in postgreSQL community Driver
Previous Message Yogi S 2018-07-23 09:11:18 copyManager Implementation :: in postgreSQL community Driver