| From: | Andreas Kretschmer <andreas(at)a-kretschmer(dot)de> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Improving pg_dump performance |
| Date: | 2018-07-23 13:27:44 |
| Message-ID: | d2b7e68c-799a-bc40-a86f-89accae0a5ca@a-kretschmer.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephen Frost | 2018-07-23 13:32:30 | Re: Improving pg_dump performance |
| Previous Message | Adrian Klaver | 2018-07-23 13:24:40 | Re: copyManager Implementation :: in postgreSQL community Driver |