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
a-z-boy.com > > *From:* Arjun Ranade [mailto:ran...@nodalexchange.com] > *Sent:* Tuesday, February 12, 2019 11:33 AM > *To:* pgsql-general@lists.postgresql.org > *Subject:* pg_dump on a standby for a very active master > > > > > *ATTENTION: This email was se

RE: pg_dump on a standby for a very active master

2019-02-12 Thread Scot Kreienkamp
: pg_dump on a standby for a very active master ATTENTION: This email was sent to La-Z-Boy from an external source. Be vigilant when opening attachments or clicking links. I have a Production machine which is having objects dropped/created/truncated at all hours of the day (Read: No zero

pg_dump on a standby for a very active master

2019-02-12 Thread Arjun Ranade
I have a Production machine which is having objects dropped/created/truncated at all hours of the day (Read: No zero activity window). I have multiple standbys (repmgr streaming replication) for this machine including a cascading standby. Each night, I am attempting to take a logical backup on th