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) harald.k...@nsn.com 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

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) harald.k...@nsn.com 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

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 si...@2ndquadrant.com 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) harald.k...@nsn.com wrote: In our use case it's important to have a short failover time.

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) harald.k...@nsn.com 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

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

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) niranja...@nsn.com 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

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 masao.fu...@gmail.com wrote: Hi, On Mon, May 4, 2009 at 11:07 PM, K, Niranjan (NSN - IN/Bangalore) niranja...@nsn.com wrote: Hi, Re-opening the discussion related to triggers to promote standby server. In the earlier dicussion, there were 2

[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