Re: Improving pg_dump performance

From: Ron <ronljohnsonjr(at)gmail(dot)com>
To:
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Improving pg_dump performance
Date: 2018-07-23 13:47:25
Message-ID: 2d90d69e-211e-32ae-8a1e-047bd55dc122@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 07/23/2018 08:46 AM, Stephen Frost wrote:
> Greetings,
>
> * Ron (ronljohnsonjr(at)gmail(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2018-07-23 13:56:11 Re: Improving pg_dump performance
Previous Message Stephen Frost 2018-07-23 13:46:00 Re: Improving pg_dump performance