Re: Improving pg_dump performance

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: Ron <ronljohnsonjr(at)gmail(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Improving pg_dump performance
Date: 2018-07-23 13:46:00
Message-ID: 20180723134600.GH27724@tamriel.snowman.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Thanks,

Stephen

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron 2018-07-23 13:47:25 Re: Improving pg_dump performance
Previous Message Ron 2018-07-23 13:42:16 Re: Improving pg_dump performance