Re: [GENERAL] Hot standby SR - log shipping required?

2013-09-14 Thread Raymond O'Donnell
On 14/09/2013 04:31, Jov wrote: T he log shipping is useful when SR slave can not catch up the master and hungry enough to cause replication stop work.For example,when you want to stop the slave for a long time or do a large copy from,the wal_keep_segments on master reached,SR slave may not

[GENERAL] Hot standby SR - log shipping required?

2013-09-13 Thread Raymond O'Donnell
Hello all, I'm tackling host standby streaming replication for the first time, in a small set-up with just two computers (one master, one standby) and an extremely light load (at its busiest, one transaction every couple of minutes). Both systems are running PG 9.1 on Debian Wheezy from

Re: [GENERAL] Hot standby SR - log shipping required?

2013-09-13 Thread Ray Stell
On Sep 13, 2013, at 3:51 PM, Raymond O'Donnell wrote: [1] and one of the wiki articles [2] seem to indicate that you need to set up log-shipping as well as SR, whereas one of the wiki articles [2] indicates that log-shipping isn't required. I've followed [3] and it seems to work fine in

Re: [GENERAL] Hot standby SR - log shipping required?

2013-09-13 Thread Jov
T he log shipping is useful when SR slave can not catch up the master and hungry enough to cause replication stop work.For example,when you want to stop the slave for a long time or do a large copy from,the wal_keep_segments on master reached,SR slave may not catch up the master.If log shipping is