Re: [GENERAL] pg_dump Conflict with recovery

2017-01-23 Thread julyanto SUTANDANG
On Tue, Jan 24, 2017 at 5:45 AM, Israel Brewster wrote: > On Jan 23, 2017, at 10:06 AM, Jerry Sievers > wrote: > > > Israel Brewster writes: > > I have a backup strategy that in part consists of doing pg_dump s on my > various databases. In order to hopefully reduce/prevent operational > slow-d

Re: [GENERAL] pg_dump Conflict with recovery

2017-01-23 Thread Israel Brewster
On Jan 23, 2017, at 10:06 AM, Jerry Sievers wrote: > > Israel Brewster writes: > >> I have a backup strategy that in part consists of doing pg_dump s on my >> various databases. In order to hopefully reduce/prevent operational >> slow-down as a result of the >> backup, I do the dumps from my

Re: [GENERAL] pg_dump Conflict with recovery

2017-01-23 Thread Jerry Sievers
Israel Brewster writes: > I have a backup strategy that in part consists of doing pg_dump s on my > various databases. In order to hopefully reduce/prevent operational slow-down > as a result of the > backup, I do the dumps from my secondary server, configured as a hot standby > with streaming

[GENERAL] pg_dump Conflict with recovery

2017-01-23 Thread Israel Brewster
I have a backup strategy that in part consists of doing pg_dump s on my various databases. In order to hopefully reduce/prevent operational slow-down as a result of the backup, I do the dumps from my secondary server, configured as a hot standby with streaming replication.In general this works fine