[ClusterLabs] Postgres 9.3, corosync and pacemaker

[Wynand Jansen van Vuuren]

aah I got it working, one of your old emails I think

restart_on_promote is a parameter of pgsql RA.
 # pcs resource update pgsql restart_on_promote=false

-- 
Regards,
Takehiro Matsushima

cl1_lb1:/opt/app/pgdata/9.3/pg_log # crm_mon -1 -Af
Last updated: Wed Mar 11 14:28:28 2015
Last change: Wed Mar 11 13:59:58 2015 by root via crm_attribute on cl1_lb1
Stack: classic openais (with plugin)
Current DC: cl1_lb1 - partition with quorum
Version: 1.1.9-2db99f1
2 Nodes configured, 2 expected votes
4 Resources configured.


Online: [ cl1_lb1 cl2_lb1 ]

 Resource Group: master-group
     vip-master	(ocf::heartbeat:IPaddr2):	Started cl1_lb1
     vip-rep	(ocf::heartbeat:IPaddr2):	Started cl1_lb1
 Master/Slave Set: msPostgresql [pgsql]
     Masters: [ cl1_lb1 ]
     Slaves: [ cl2_lb1 ]

Node Attributes:
* Node cl1_lb1:
    + master-pgsql                    	: 1000
    + pgsql-data-status               	: LATEST
    + pgsql-master-baseline           	: 000000087D0000C8
    + pgsql-status                    	: PRI
* Node cl2_lb1:
    + master-pgsql                    	: 100
    + pgsql-data-status               	: STREAMING|SYNC
    + pgsql-status                    	: HS:sync

Migration summary:
* Node cl1_lb1:
* Node cl2_lb1:
cl1_lb1:/opt/app/pgdata/9.3/pg_log #

Tested failover, works like a charm, thanks so much



On Wed, Mar 11, 2015 at 1:56 PM, Takehiro Matsushima <
takehiro.dreamizm at gmail.com> wrote:

> Hi Wynand,
>
> How about specify "tmpdir" param?
> pgsql RA tries to create a lock file in "tmpdir" specified.
>
> Regards,
> Takehiro Matsushima
>
> _______________________________________________
> Users mailing list: Users at clusterlabs.org
> http://clusterlabs.org/mailman/listinfo/users
>
> Project Home: http://www.clusterlabs.org
> Getting started: http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf
> Bugs: http://bugs.clusterlabs.org
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.clusterlabs.org/pipermail/users/attachments/20150311/e318f3a9/attachment-0003.html>