| From: | Magnus Hagander <magnus(at)hagander(dot)net> |
|---|---|
| To: | Tatsuo Ishii <ishii(at)postgresql(dot)org> |
| Cc: | masao(dot)fujii(at)gmail(dot)com, heikki(dot)linnakangas(at)enterprisedb(dot)com, itagaki(dot)takahiro(at)gmail(dot)com, tgl(at)sss(dot)pgh(dot)pa(dot)us, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: pg_ctl failover Re: Latches, signals, and waiting |
| Date: | 2011-01-28 07:57:59 |
| Message-ID: | AANLkTimXOAtZx6Cj+USbcsDbnaRvWA5T52tw_ykdF9PQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Fri, Jan 28, 2011 at 08:44, Tatsuo Ishii <ishii(at)postgresql(dot)org> wrote:
>>> I did s/failover/promote. Here is the updated patch.
>>
>> I rebased the patch to current git master.
>
> I'm thinking about implementing a function which does a promotion for
> the standby. It will make pgpool lot easier to control the promotion
> since it allow to fire the promotion operation (either creating a
> trigger file or sending a signal) via SQL, not ssh etc.
I agree that having this available via SQL would be useful in a number
of cases. pgpool or such being one, but also for example pgadmin.
> If there's enough interest, I will propose such a function for next CF.
Just as a reminder, remember that next CF means 9.2.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tatsuo Ishii | 2011-01-28 08:09:50 | Re: pg_ctl failover Re: Latches, signals, and waiting |
| Previous Message | Jeff Davis | 2011-01-28 07:45:30 | Re: WIP: RangeTypes |