[ClusterLabs] Problem with Pacemaker and PostgreSQL

[FLORAC Thierry]

Hi,

I'm using two Debian 12.8 servers and I'm trying to create a basic PostgreSQL cluster using Pacemaker (2.1.5) and Corosync (3.1.7).
I created two resources using pgsqlms and IPaddr2, and this is the output of "crm configure show":

node 1: xpgl98-020 \
        attributes master-integration=1001
node 2: xpgl98-021 \
        attributes master-integration=1000
primitive integration-pgsql pgsqlms \
        params bindir="/usr/lib/postgresql/15/bin" pgdata="/var/local/postgresql/15/integration" pgport=5432 start_opts="-c config_file=/etc/postgresql/15/integration/postgresql.conf" \
        op demote timeout=120s interval=0s \
        op methods interval=0s timeout=5 \
        op monitor interval=15s timeout=10s role=Promoted \
        op monitor interval=16s timeout=10s role=Unpromoted \
        op notify timeout=60s interval=0s \
        op promote timeout=30s interval=0s \
        op reload interval=0s timeout=20 \
        op start timeout=60s interval=0s \
        op stop timeout=60s interval=0s
primitive integration-vip IPaddr2 \
        params ip=172.22.71.222 iflabel=integ \
        op monitor interval=15s \
        op start interval=0s timeout=20s \
        op stop interval=0s timeout=20s \
        meta target-role=Started
clone integration-pgsql-clone integration-pgsql \
        meta notify=true target-role=Master promotable=true
location integration-pgsql-loc integration-pgsql-clone role=Started inf: xpgl98-020
colocation integration-pgsql-vip inf: integration-vip:Started integration-pgsql-clone:Promoted
order integration-vip-after-pgsql-start Mandatory: integration-pgsql-clone:promote integration-vip:start symmetrical=false
order integration-vip-after-pgsql-stop Mandatory: integration-pgsql-clone:demote integration-vip:stop symmetrical=false
location integration-vip-loc integration-vip role=Started inf: xpgl98-020
property cib-bootstrap-options: \
        stonith-enabled=false \
        last-lrm-refresh=1735223668 \
        have-watchdog=false \
        dc-version=2.1.5-a3f44794f94 \
        cluster-infrastructure=corosync \
        cluster-name=pgsql-noprod
And this is the output of 'crm status':
Status of pacemakerd: 'Pacemaker is running' (last updated 2024-12-26 15:34:56 +01:00)
Cluster Summary:
  * Stack: corosync
  * Current DC: xpgl98-021 (version 2.1.5-a3f44794f94) - partition with quorum
  * Last updated: Thu Dec 26 15:34:57 2024
  * Last change:  Thu Dec 26 15:34:28 2024 by hacluster via crmd on xpgl98-020
  * 2 nodes configured
  * 3 resource instances configured

Node List:
  * Online: [ xpgl98-020 xpgl98-021 ]

Full List of Resources:
  * integration-vip     (ocf:heartbeat:IPaddr2):         Stopped
  * Clone Set: integration-pgsql-clone [integration-pgsql] (promotable):
    * Stopped (invalid parameter): [ xpgl98-020 xpgl98-021 ]
As you can see, I get an "invalid parameter" in "integration-pgsql-clone" resource, but I can't see which is the related parameter!
Any idea?

Best regards,
Thierry
--
Thierry Florac
Resp. pôle Architecture Applicative et Mobile
DSI / Département des Études et Solutions Transverses
2 bis avenue du Général Leclerc - CS 30042 - 94704 Maisons-Alfort Cedex
Tél : 01 40 19 59 64 - 06 26 53 42 09
www.onf.fr<https://www.onf.fr/>
[https://www.ext.onf.fr/img/onf-signature.jpg]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.clusterlabs.org/pipermail/users/attachments/20241226/1186c6a7/attachment.htm>