Postgres Professional
   

Synchronous replication: Promotion of Standby to Primary

From: K, Niranjan (NSN - IN/Bangalore)
Subject: Synchronous replication: Promotion of Standby to Primary
Date: ,
Msg-id: 985D3C447786074E957A9001D62CDDD05A367A@SGSIEXC009.nsn-intra.net
(view: Whole thread, Raw)
Responses: Re: Synchronous replication: Promotion of Standby to Primary  (Fujii Masao)
List: pgsql-hackers

Tree view

Synchronous replication: Promotion of Standby to Primary  ("K, Niranjan (NSN - IN/Bangalore)", )
 Re: Synchronous replication: Promotion of Standby to Primary  (Fujii Masao, )
  Re: Synchronous replication: Promotion of Standby to Primary  (Fujii Masao, )
   Re: Synchronous replication: Promotion of Standby to Primary  ("Kolb, Harald (NSN - DE/Munich)", )
 Re: Synchronous replication: Promotion of Standby to Primary  (Fujii Masao, )
 Re: Synchronous replication: Promotion of Standby to Primary  (Fujii Masao, )
  Re: Synchronous replication: Promotion of Standby to Primary  (Simon Riggs, )
   Re: Synchronous replication: Promotion of Standby to Primary  (Fujii Masao, ) 
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 to the proposal, it seems to be better if signals are used as
we can avoid checking the file existance in the loop. Or the other
approach is to use inotify (http://en.wikipedia.org/wiki/Inotify). But
portability to other unix like OS is an issue to look for.

Could you please get back which is being implemented/ considered for
promotion of standby?

regards,
Niranjan

pgsql-hackers by date:

Previous:
From: Peter Eisentraut
Date:
Subject: Re: Unicode string literals versus the world
Next:
From: Tom Lane
Date:
Subject: Re: windows doesn't notice backend death