[Pacemaker] Multi-site configuration for PGSQL RA

[Takatoshi MATSUO]

Hi Richard

2013/11/3 Richard Colley <rcolley at cardaccess.com.au>:
>>
>> This ?
>>
>> https://github.com/t-matsuo/resource-agents/wiki/Resource-agent-for-postgresql-9.2-for-disaster(split)-site
>>
>> You can use rep_mode="slave".
>>
>> Takatoshi MATSUO
>>
>
> Hi Takatoshi, that helps a lot.
>
> How would you cutover between sites?  It seems like I'd need to delete the
> resources at each site, and re-create them.

I  think it's possible using a ticket.

>  Are there any risks doing that?

About deleting primitive resources and creating master/slave resource manually ?
It means building a new cluster, so I think it does not have many risks.

> Or is there some easier way to cutover?  Do you see no benefit in the mysql
> ra approach of using a ticket to identify the active vs passive site?

No, I don't.
I have never used mysql RA as master/slave resource.

>
> Thanks,
> Richard

Regards,
Takatoshi