| Lists: | pgsql-hackers |
|---|
| From: | Tatsuo Ishii <ishii(at)postgresql(dot)org> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Synchronous standby |
| Date: | 2011-02-23 08:49:21 |
| Message-ID: | 20110223.174921.747158203459046339.t-ishii@sraoss.co.jp |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
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).
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.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp
| From: | Jaime Casanova <jaime(at)2ndquadrant(dot)com> |
|---|---|
| To: | Tatsuo Ishii <ishii(at)postgresql(dot)org> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Synchronous standby |
| Date: | 2011-02-23 17:09:15 |
| Message-ID: | AANLkTin=V0jYszMeUPRCfpYHZOZinGonpR1Au9gfe3m3@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
On Wed, Feb 23, 2011 at 3:49 AM, Tatsuo Ishii <ishii(at)postgresql(dot)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
| From: | Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp> |
|---|---|
| To: | jaime(at)2ndquadrant(dot)com |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Synchronous standby |
| Date: | 2011-02-24 02:00:18 |
| Message-ID: | 20110224.110018.292043055561895565.t-ishii@sraoss.co.jp |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
> On Wed, Feb 23, 2011 at 3:49 AM, Tatsuo Ishii <ishii(at)postgresql(dot)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