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]
_______________________________________________
Manage your subscription:
https://lists.clusterlabs.org/mailman/listinfo/users
ClusterLabs home: https://www.clusterlabs.org/
