Postgres Pro
Downloads
Home   >   mailing lists

Re: Improving pg_dump performance - Mailing list pgsql-general

From Andres Freund
Subject Re: Improving pg_dump performance
Date
Msg-id 20180723141140.wr552tyoxidb6stl@alap3.anarazel.de
Whole thread Raw
In response to Improving pg_dump performance  (Ron <ronljohnsonjr@gmail.com>)
Responses Re: Improving pg_dump performance  (Ron <ronljohnsonjr@gmail.com>)
List pgsql-general
Tree view 
Hi,

On 2018-07-23 02:23:45 -0500, Ron wrote:
> 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.

Have you considered using pg_upgrade instead?

Greetings,

Andres Freund

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Improving pg_dump performance
Next
From: Chris Travers
Date:
Subject: Replication protocol question for logical replication.