Re: Improving pg_dump performance

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 07:32:41
Message-ID: afa64b21-b9ba-4a0e-2c6b-5a7f7d3e5bb7@a-kretschmer.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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)

Regards, Andreas

--
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Yogi S 2018-07-23 09:11:18 copyManager Implementation :: in postgreSQL community Driver
Previous Message Ron 2018-07-23 07:23:45 Improving pg_dump performance