From: Stephen Frost <sfrost@snowman.net>
To: Arjun Ranade <ranade@nodalexchange.com>
Cc: Scot Kreienkamp <Scot.Kreienkamp@la-z-boy.com>
Cc: pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>
Subject: Re: pg_dump on a standby for a very active master
Date: Tue, 12 Feb 2019 12:59:40 -0500
Message-ID: <20190212175940.GQ6197@tamriel.snowman.net> (raw)
In-Reply-To: <CANrrCRynnCD7wDuU=um+GxVU1ikBVS3cTpoQ7v8Gt9E4PPURjg@mail.gmail.com>
References: <CANrrCRwwUOj4d6iaXtbmOk02NBKdjLF2XuqBNyZRRttT1iBsgA@mail.gmail.com>
<CANrrCRyGHDkRo+phd-3nyKRBcHtNAHPwtkJi1RDD8yhRCQzVpQ@mail.gmail.com>
<17082AAFC33A934082836458CB53494374EB7F55@MONDB03.na.lzb.hq>
<CANrrCRynnCD7wDuU=um+GxVU1ikBVS3cTpoQ7v8Gt9E4PPURjg@mail.gmail.com>
Greetings,
* Arjun Ranade (ranade@nodalexchange.com) wrote:
> Yeah, that was one thing I was planning to try. The other potential
> solution is to use barman (we are using barman on all db servers including
> standbys) to restore the latest backup to a VM and then take the pg_dump
> from there. But I was hoping there would be a way in the settings to
> prevent such a workaround.
Performing a file-level backup and then restoring that and then
taking a pg_dump of restored cluster works quite well as a solution, in
my experience, even better is when you can do a delta restore over top
of the prior restore, updating just the files which were different, as
that can be much faster.
Thanks!
Stephen
Attachments:
signature.asc (application/pgp-signature, 818B) download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: sfrost@snowman.net, ranade@nodalexchange.com, Scot.Kreienkamp@la-z-boy.com, pgsql-general@lists.postgresql.org
Subject: Re: pg_dump on a standby for a very active master
In-Reply-To: <20190212175940.GQ6197@tamriel.snowman.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox