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...

--
Jaime Casanova         www.2ndQuadrant.com
Professional PostgreSQL: Soporte y capacitación de PostgreSQL

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