Re: [HACKERS] Synchronous replication: Promotion of Standby to Primary

2009-05-27 Thread Fujii Masao
Hi, On Wed, May 27, 2009 at 10:49 PM, Simon Riggs wrote: > > On Wed, 2009-05-27 at 21:28 +0900, Fujii Masao wrote: >> Hi, >> >> On Wed, May 27, 2009 at 3:27 PM, Kolb, Harald (NSN - DE/Munich) >> wrote: >> > In our use case it's important to have a short failover time. >> > So everything what kee

Re: [HACKERS] Synchronous replication: Promotion of Standby to Primary

2009-05-27 Thread Simon Riggs
On Wed, 2009-05-27 at 21:28 +0900, Fujii Masao wrote: > Hi, > > On Wed, May 27, 2009 at 3:27 PM, Kolb, Harald (NSN - DE/Munich) > wrote: > > In our use case it's important to have a short failover time. > > So everything what keeps the time low, would be good to have. > > Yes. I think that it's

Re: [HACKERS] Synchronous replication: Promotion of Standby to Primary

2009-05-27 Thread Fujii Masao
Hi, On Wed, May 27, 2009 at 3:27 PM, Kolb, Harald (NSN - DE/Munich) wrote: > In our use case it's important to have a short failover time. > So everything what keeps the time low, would be good to have. Yes. I think that it's a matter of priority. > We already made some failover investigations

Re: [HACKERS] Synchronous replication: Promotion of Standby to Primary

2009-05-25 Thread Kolb, Harald (NSN - DE/Munich)
Hello Fujii, my name is Harald Kolb, I'm a colleague of Niranjan and I will continue his community work since he's currently busy with other topics. We are looking for a fast mechanism to activate the switchover. Therfore we prefer to use a signal to trigger the standby to become primary, since in

Re: [HACKERS] Synchronous replication: Promotion of Standby to Primary

2009-05-25 Thread Fujii Masao
Hi, On Mon, May 25, 2009 at 7:10 PM, Kolb, Harald (NSN - DE/Munich) wrote: > Hello Fujii, > > my name is Harald Kolb, I'm a colleague of Niranjan and I will continue > his community work since he's currently busy with other topics. > We are looking for a fast mechanism to activate the switchover.

Re: [HACKERS] Synchronous replication: Promotion of Standby to Primary

2009-05-14 Thread Fujii Masao
Hi, On Thu, May 14, 2009 at 8:16 PM, Fujii Masao wrote: > Hi, > > On Mon, May 4, 2009 at 11:07 PM, K, Niranjan (NSN - IN/Bangalore) > wrote: >> Hi, >> >> Re-opening the discussion related to triggers to promote standby server. >> In the earlier dicussion, there were 2 proposals, Trigger based on

Re: [HACKERS] Synchronous replication: Promotion of Standby to Primary

2009-05-14 Thread Fujii Masao
Hi, On Mon, May 4, 2009 at 11:07 PM, K, Niranjan (NSN - IN/Bangalore) wrote: > Hi, > > Re-opening the discussion related to triggers to promote standby server. > In the earlier dicussion, there were 2 proposals, Trigger based on file > and trigger based on signals. I think there was no conclusion

[HACKERS] Synchronous replication: Promotion of Standby to Primary

2009-05-04 Thread K, Niranjan (NSN - IN/Bangalore)
Hi, Re-opening the discussion related to triggers to promote standby server. In the earlier dicussion, there were 2 proposals, Trigger based on file and trigger based on signals. I think there was no conclusion on this. http://archives.postgresql.org/pgsql-hackers/2008-12/msg01231.php According t