Re: pg_dump on a standby for a very active master

2019-02-12 Thread Stephen Frost
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

Re: pg_dump on a standby for a very active master

2019-02-12 Thread Arjun Ranade
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

Re: pg_dump on a standby for a very active master

2019-02-12 Thread Stephen Frost
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.

Re: pg_dump on a standby for a very active master

2019-02-12 Thread Arjun Ranade
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

RE: pg_dump on a standby for a very active master

2019-02-12 Thread Scot Kreienkamp
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