Re: Improving pg_dump performance - Mailing list pgsql-general

From Stephen Frost
Subject Re: Improving pg_dump performance
Date
Msg-id 20180723134600.GH27724@tamriel.snowman.net
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
Greetings,

* Ron (ronljohnsonjr@gmail.com) wrote:
> An interesting idea.  To clarify: it's possible to parallel backup a running
> 8.4 cluster remotely from a 9.6 system?

Yes, you can do a parallel backup, but you won't be able to get a
consistent snapshot.  You'll need to pause all changes to the database
while the pg_dump processes connect and start their transactions to
have the backup be consistent.

Thanks,

Stephen

Attachment

pgsql-general by date:

Previous
From: Ron
Date:
Subject: Re: Improving pg_dump performance
Next
From: Ron
Date:
Subject: Re: Improving pg_dump performance