Re: [Linux-HA] Unable to start any node of pgsql Master/Slave Cluster

the psql command. I have no knowledge of PG9.3. But these logs may be output by SQL "select now()" on template1 db, so you can check PostgreSQL status manulally during starting-up too. Thanks, Takatoshi MATSUO 2014-09-19 19:57 GMT+09:00 Oliver Weichhold : > Okay, I've tried

Re: [Linux-HA] How to restart cluster ?

Hi jarek Do you use pgsql RA with Master/Slave setting ? I recommend you to stop slave node's pacemaker at first because pgsql RA removes PGSQL.lock automatically if the node is master and there is no slaves. Stop procedure 1. stop slave node -> suppose nodeB 2. stop master node (PGSQL.l

Re: [Linux-HA] A question of pgsql resource

> shutdown(-m i) command has timed out. > > What do you think abount my opinion ? I think it makes sense. But I would like you to keep current stopping process because I think it's safer to use STONITH. Could you implement it adding new parameter if you implement? BTW, is it

Re: [Linux-HA] How to tell master-slave group set one node to master?

2013/12/8 Andrey Rogovsky : > 1. Yes > 2. No > 3. I have 3 nodes > 4. Have this errors: > Dec 7 17:35:28 a lrmd: [2452]: info: RA output: (pgsql:0:monitor:stderr) > /usr/lib/ocf/resource.d//heartbeat/pgsql: 1749: /usr/lib/ocf > /resource.d//heartbeat/pgsql: > Dec 7 17:35:28 a lrmd: [2452]: info:

Re: [Linux-HA] How to tell master-slave group set one node to master?

l-data-status" -D # crm_attribute -l forever -N b -n "pgsql-data-status" -D # crm_attribute -l forever -N c -n "pgsql-data-status" -D After that, pgsql RA begins to compare data and promotes PostgreSQL which has latest data. Thanks, Takatoshi MATSUO 2013/12/7 Andrey Rogovsk

Re: [Linux-HA] does migration-threshold act differently on master/slave clones?

y say that PostgreSQL 9.4 may be able to avoid it in the future. Thanks, Takatoshi MATSUO 2013/7/17 Jeff Frost : > Since I've been playing with the pgsql resource agent, it seems as though > migration-threshold is ignored on the master node. > > That is, when I stop the postgresql

Re: [Linux-HA] problem with pgsql streaming resource agent

Hi Jeff Frost For your reference, I succeed with this setting under fedora 19 (pcs-0.9.48-1.fc19.x86_64). https://github.com/t-matsuo/resource-agents/wiki/Other-sample-settings-for-pgsql-RA-with-replication Thanks, Takatoshi MATSUO 2013/7/16 Jeff Frost : > On 07/08/13 17:17, Jeff Frost wr

Re: [Linux-HA] problem with pgsql streaming resource agent

Does resource-agents-3.9.2-21.el6_4.3.x86_64 include this patch ? https://github.com/ClusterLabs/resource-agents/commit/ffc9c6444996144076ef2b4bc79a38569e05250a#heartbeat/pgsql I recommed you to use latest pgsql RA. https://raw.github.com/ClusterLabs/resource-agents/bb62ffcd8381884a8e498f85f1861c2

Re: [Linux-HA] cannot compile cluster-glue under fedora 18

Hi Dejan Thank you for making a patch. I succeeded in compiling it under Fedora18 and RHEL6. Regards, Takatoshi MATSUO 2013/6/6 Dejan Muhamedagic : > Hi, > > On Mon, May 13, 2013 at 08:58:50PM +0900, Takatoshi MATSUO wrote: >> Hi >> >> I am compiling cluster-glue

[Linux-HA] cannot compile cluster-glue under fedora 18

ings being treated as errors gmake[2]: *** [strlcpy.lo] Error 1 gmake[2]: Leaving directory `/root/rpmbuild/BUILD/cluster-glue/replace' ----- Regards, Takatoshi MATSUO ___ Linux-HA mailing list Linux-HA@lists.linux-ha.org htt