> On Wed, Feb 23, 2011 at 3:49 AM, Tatsuo Ishii <is...@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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers