Re: Synchronous standby

> On Wed, Feb 23, 2011 at 3:49 AM, Tatsuo Ishii <ishii@postgresql.org> wrote:
>> In 9.1, we will be able to have synchrnous replication. Also we have
>> one standby server chosen by primary to be the synchronous standby
>> (still I'm not sure this is correct or not as stated in another mail).
>>
> 
> yes, it is. a list of possible synch standbys and one of them chosen
> to be the one
> 
>> Is there anyway to know which is the synchronous standby? IMO this is
>> important for users because that one is likely the least behind to
>> primary and will be chosen to promoto in case of primary dying in most
>> cases.
> 
> i guess, we can put a new column in pg_stat_replication stating the
> type of the replication (synch or asynch).
> but that is surely a different patch...

Ok, I will write a patch unless someone comes up.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp