From: | Cédric Villemain <cedric(dot)villemain(dot)debian(at)gmail(dot)com> |
---|---|
To: | Jody McIntyre <jodym(at)trustcentric(dot)com> |
Cc: | Fujii Masao <masao(dot)fujii(at)gmail(dot)com>, pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Heartbeat + pacemaker configuration for PostgreSQL log shipping |
Date: | 2011-02-22 17:22:01 |
Message-ID: | AANLkTikPA2hBn5b9WVJBtxmtw5wEMoAii9W4y-h+0yrm@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
2011/2/22 Jody McIntyre <jodym(at)trustcentric(dot)com>:
> On Mon, Feb 21, 2011 at 10:00 PM, Fujii Masao <masao(dot)fujii(at)gmail(dot)com> wrote:
>>
>> The resource agents for MySQL and DRBD have been implemented as
>> master/slave ones. So I think that the resource agent for PostgreSQL also
>> should be done the same way, i.e., you should implement only "start" and
>> "stop" but also "promote" and "demote".
>
> The trouble with postgres is there's no easy way to "demote" a master
> machine to a slave. You need to create a new master, back up its database,
> and restore it onto the slave before starting it. This seems difficult to
> implement, and pacemaker is already very complicated as it is.
>
> We are seriously considering writing our own tool that simply tests the
> master from the slave, and runs a very simple shell script to take over if
> necessary.
>
We have some work in progress in repmgr for that. And it offers
stronger choice when you have several standby and want to pick the
most up to date to become a new master.
--
Cédric Villemain 2ndQuadrant
http://2ndQuadrant.fr/ PostgreSQL : Expertise, Formation et Support
From | Date | Subject | |
---|---|---|---|
Next Message | Bernhard Rohrer | 2011-02-22 18:41:11 | Re: PG_update to 9.0.4 in ubuntu lucid 64 |
Previous Message | Bernhard Schrader | 2011-02-22 17:07:53 | Re: PG_update to 9.0.4 in ubuntu lucid 64 |