There is bug in PCS 0.9.26: configure pacemaker resource agent for PG stream replication

From: leo <dazhoufei(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: There is bug in PCS 0.9.26: configure pacemaker resource agent for PG stream replication
Date: 2014-03-07 06:32:39
Message-ID: 1394173959207-5795081.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,

I just complete my HA configuration on Redhat 6.4 enterprise:
Clusterware: Pacemaker 1.1.8 ( CMAN .0.12.1, corosync 1.4.1 )
Resource manager: PCS 0.9.26
PostgreSQL 9.3.3.1
Detailed configuration follow:
http://clusterlabs.org/wiki/PgSQL_Replicated_Cluster#PostgreSQL_.28node1_only.29

Complete the configuration, we find all PostgreSQL is slave status. We
finally find the root cause after google searching. PCS don't apply all
resource configuration definition, it cut configuration parameter at end of
the first "op"
For example:
pcs -f pgsql_cfg resource create pgsql pgsql \
pgctl="/usr/bin/pg_ctl" \
psql="/usr/bin/psql" \
pgdata="/var/lib/pgsql/data/" \
rep_mode="sync" \
node_list="node1 node2" \
restore_command="cp /var/lib/pgsql/pg_archive/%f %p" \
primary_conninfo_opt="keepalives_idle=60 keepalives_interval=5
keepalives_count=5" \
master_ip="192.168.2.3" \
restart_on_promote='true' \
op start timeout="60s" interval="0s" on-fail="restart" \
==============Other op definition is cut
After we upgrade PCS version to the latest 0.9.90. All problem disappear
:)

BWT, we find the app connection does not be interrupted when RA
automatically switch sync replication to async replication ( for example we
kill the slave node).

--
View this message in context: http://postgresql.1045698.n5.nabble.com/There-is-bug-in-PCS-0-9-26-configure-pacemaker-resource-agent-for-PG-stream-replication-tp5795081.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Paquier 2014-03-07 12:10:32 Re: There is bug in PCS 0.9.26: configure pacemaker resource agent for PG stream replication
Previous Message Adrian Klaver 2014-03-07 00:21:28 Re: problem with trigger function