Greetings,
* Arjun Ranade (ran...@nodalexchange.com) wrote:
> Will barman automatically do a delta restore assuming the postgres server
> is stopped and the old cluster exists at the same location it's restoring
> to?
I don't know if barman supports that today, it might. I do know that
pgbackres
Will barman automatically do a delta restore assuming the postgres server
is stopped and the old cluster exists at the same location it's restoring
to?
On Tue, Feb 12, 2019 at 12:59 PM Stephen Frost wrote:
> Greetings,
>
> * Arjun Ranade (ran...@nodalexchange.com) wrote:
> > Yeah, that was one t
Greetings,
* Arjun Ranade (ran...@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.
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
How about pausing replication while you’re running the backup? I have a mirror
dedicated to backups, it pauses replication by cron job every night before the
backup, then resumes midday after I’ve had enough time to find out if the
backup was successful.
Scot Kreienkamp |Senior Systems Engine