Re: [HACKERS] How to avoid base backup in automated failover

2012-10-17 Thread Amit Kapila
On Wednesday, October 17, 2012 11:22 AM chinnaobi wrote: Hey Haas, What does the standby server have to wait for replication to catch up before promoting ?? Is there any parameter to configure this ?? Few more questions on this part 1. How could we ensure the standby has received all

Re: [HACKERS] How to avoid base backup in automated failover

2012-10-17 Thread chinnaobi
Hey Amitkapila, Thank you for the quick reply. How can implement this patch in windows, because I am using windows 9.1.1 postgreSQL application ?? -- View this message in context: http://postgresql.1045698.n5.nabble.com/How-to-avoid-base-backup-in-automated-failover-tp5711147p5728562.html

Re: [HACKERS] How to avoid base backup in automated failover

2012-10-17 Thread Amit Kapila
On Wednesday, October 17, 2012 3:09 PM chinnaobi wrote: Hey Amitkapila, Thank you for the quick reply. How can implement this patch in windows, because I am using windows 9.1.1 postgreSQL application ?? If the patch serves the feature you require, then once it gets committed (there are

Re: [HACKERS] How to avoid base backup in automated failover

2012-10-16 Thread chinnaobi
Hey Haas,What does the standby server have to wait for replication to catch up before promoting ?? Is there any parameter to configure this ??Few more questions on this part 1. How could we ensure the standby has received all transactions sent by primary till the point primary server is dead.

Re: [HACKERS] How to avoid base backup in automated failover

2012-10-16 Thread chinnaobi
Hey Haas, What does the standby server have to wait for replication to catch up before promoting ?? Is there any parameter to configure this ?? Few more questions on this part 1. How could we ensure the standby has received all transactions sent by primary till the point primary server is

Re: [HACKERS] How to avoid base backup in automated failover

2012-06-26 Thread Robert Haas
On Mon, Jun 4, 2012 at 9:14 AM, chinnaobi chinna...@gmail.com wrote: Recently I was writing an application to implement automated failover with env: Two 2008 R2 servers, Network area storage, asynchronous replication, WAL archive on primary enabled. Is there any way to avoid starting standby

[HACKERS] How to avoid base backup in automated failover

2012-06-04 Thread chinnaobi
Hi all, Recently I was writing an application to implement automated failover with env: Two 2008 R2 servers, Network area storage, asynchronous replication, WAL archive on primary enabled. Is there any way to avoid starting standby server always from base backup in automated failover. I see the