Re: Improving pg_dump performance - Mailing list pgsql-general

From Ron
Subject Re: Improving pg_dump performance
Date
Msg-id 2d90d69e-211e-32ae-8a1e-047bd55dc122@gmail.com
Whole thread Raw
In response to Re: Improving pg_dump performance  (Stephen Frost <sfrost@snowman.net>)
Responses Re: Improving pg_dump performance  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
On 07/23/2018 08:46 AM, Stephen Frost wrote:
> 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.

I can do that!!!

-- 
Angular momentum makes the world go 'round.


pgsql-general by date:

Previous
From: Stephen Frost
Date:
Subject: Re: Improving pg_dump performance
Next
From: Adrian Klaver
Date:
Subject: Re: Improving pg_dump performance