Vous n'êtes pas identifié(e).
Pages : 1
Non justement c'est pas root... Il y a pas un problème avec repmgr. J'ai du aussi faire dans mon home du user un lien vers mon fichier repmgr.conf car dans les traces du DEBUG mon -f xxx/xxx/repmgr.conf devient -f ./repmgr.conf.
Bonjour,
Je suis dans la situation suivante :
ID | Name | Role | Status | Upstream | Location | Connection string
----+--------+---------+-----------+----------+----------+-----------------------------------------------------------------------
1 | PRMDBA | primary | * running | | default | host=172.22.20.42 port=5128 user=repmgr dbname=DBA1 connect_timeout=2
2 | ST1DBA | standby | running | PRMDBA | default | host=172.22.28.52 port=5128 user=repmgr dbname=DBA1 connect_timeout=2
3 | ST2DBA | standby | running | PRMDBA | default | host=172.22.20.43 port=5128 user=repmgr dbname=DBA1 connect_timeout=2
Lorsque je coupe PRMDBA , le promote commande ne fonctionne pas en automique sur ST1DBA (marche en manuel) :
promote_command='/usr/pgsql-10/bin/repmgr standby promote -f /etc/repmgr/10/repmgr.conf --log-to-file'
J'ai bien un daemon qui tourne :
rfrbpdba 31635 1 0 15:38 ? 00:00:00 /usr/pgsql-10/bin/repmgrd -f /etc/repmgr/10/repmgr.conf
Avez vous une idée ?.
Merci
Pour que cela fonctionne je dois ajouter pg_ctl dans le PATH de root.
La commande repmgr switchover ne trouve pas pg_ctl :
/usr/pgsql-10/bin/repmgr standby switchover -f /etc/repmgr/10/repmgr.conf --remote-user rfrbpdba --siblings-follow
DEBUG: connecting to: "user=repmgr connect_timeout=2 dbname=DBA1 host=172.22.20.42 port=5128 fallback_application_name=repmgr"
NOTICE: executing switchover on node "PRMDBA" (ID: 1)
DEBUG: connecting to: "user=repmgr connect_timeout=2 dbname=DBA1 host=172.22.28.52 port=5128 fallback_application_name=repmgr"
DEBUG: remote_command():
ssh -o Batchmode=yes -q -o ConnectTimeout=10 rfrbpdba@172.22.28.52 /usr/pgsql-10/bin/repmgr -f ./repmgr.conf --version 2>/dev/null && echo "1" || echo "0"
WARNING: option "--sibling-nodes" specified, but no sibling nodes exist
DEBUG: remote_command():
ssh -o Batchmode=yes -q -o ConnectTimeout=10 rfrbpdba@172.22.28.52 /usr/pgsql-10/bin/repmgr -f ./repmgr.conf node check --remote-node-id=1 --replication-connection
DEBUG: connecting to: "user=repmgr connect_timeout=2 dbname=DBA1 host=172.22.28.52 port=5128 fallback_application_name=repmgr"
DEBUG: remote_command():
ssh -o Batchmode=yes -q -o ConnectTimeout=10 rfrbpdba@172.22.28.52 /usr/pgsql-10/bin/repmgr -f ./repmgr.conf node check --terse -LERROR --archive-ready --optformat
DEBUG: lag is 0
DEBUG: minimum of 1 free slots (0 for siblings) required; 3 available
DEBUG: connecting to: "user=repmgr connect_timeout=2 dbname=DBA1 host=172.22.20.42 port=5128 fallback_application_name=repmgr"
DEBUG: connecting to: "user=repmgr connect_timeout=2 dbname=DBA1 host=172.22.28.52 port=5128 fallback_application_name=repmgr"
NOTICE: local node "PRMDBA" (ID: 1) will be promoted to primary; current primary "ST1DBA" (ID: 2) will be demoted to standby
NOTICE: stopping current primary node "ST1DBA" (ID: 2)
DEBUG: remote_command():
ssh -o Batchmode=yes -q -o ConnectTimeout=10 rfrbpdba@172.22.28.52 /usr/pgsql-10/bin/repmgr -f ./repmgr.conf node service --action=stop --checkpoint
DEBUG: connecting to: "user=repmgr connect_timeout=2 dbname=DBA1 host=172.22.28.52 port=5128 fallback_application_name=repmgr"
NOTICE: issuing CHECKPOINT
DETAIL: executing server command "pg_ctl stop -D /rece/fr/DBA/pgrdb/RFRDBA1/pgdata"
sh: pg_ctl: command not found
INFO: checking for primary shutdown; 1 of 60 attempts ("shutdown_check_timeout")
DEBUG: ping status is: PQPING_OK
DEBUG: sleeping 1 second until next check
INFO: checking for primary shutdown; 2 of 60 attempts ("shutdown_check_timeout")
DEBUG: ping status is: PQPING_OK
DEBUG: sleeping 1 second until next check
INFO: checking for primary shutdown; 3 of 60 attempts ("shutdown_check_timeout")
DEBUG: ping status is: PQPING_OK
DEBUG: sleeping 1 second until next check
INFO: checking for primary shutdown; 4 of 60 attempts ("shutdown_check_timeout")
DEBUG: ping status is: PQPING_OK
DEBUG: sleeping 1 second until next check
INFO: checking for primary shutdown; 5 of 60 attempts ("shutdown_check_timeout")
DEBUG: ping status is: PQPING_OK
DEBUG: sleeping 1 second until next check
INFO: checking for primary shutdown; 6 of 60 attempts ("shutdown_check_timeout")
DEBUG: ping status is: PQPING_OK
DEBUG: sleeping 1 second until next check
INFO: checking for primary shutdown; 7 of 60 attempts ("shutdown_check_timeout")
DEBUG: ping status is: PQPING_OK
DEBUG: sleeping 1 second until next check
INFO: checking for primary shutdown; 8 of 60 attempts ("shutdown_check_timeout")
DEBUG: ping status is: PQPING_OK
DEBUG: sleeping 1 second until next check
INFO: checking for primary shutdown; 9 of 60 attempts ("shutdown_check_timeout")
DEBUG: ping status is: PQPING_OK
DEBUG: sleeping 1 second until next check
INFO: checking for primary shutdown; 10 of 60 attempts ("shutdown_check_timeout")
DEBUG: ping status is: PQPING_OK
DEBUG: sleeping 1 second until next check
INFO: checking for primary shutdown; 11 of 60 attempts ("shutdown_check_timeout")
DEBUG: ping status is: PQPING_OK
DEBUG: sleeping 1 second until next check
INFO: checking for primary shutdown; 12 of 60 attempts ("shutdown_check_timeout")
DEBUG: ping status is: PQPING_OK
DEBUG: sleeping 1 second until next check
INFO: checking for primary shutdown; 13 of 60 attempts ("shutdown_check_timeout")
DEBUG: ping status is: PQPING_OK
DEBUG: sleeping 1 second until next check
INFO: checking for primary shutdown; 14 of 60 attempts ("shutdown_check_timeout")
DEBUG: ping status is: PQPING_OK
DEBUG: sleeping 1 second until next check
INFO: checking for primary shutdown; 15 of 60 attempts ("shutdown_check_timeout")
DEBUG: ping status is: PQPING_OK
DEBUG: sleeping 1 second until next check
INFO: checking for primary shutdown; 16 of 60 attempts ("shutdown_check_timeout")
DEBUG: ping status is: PQPING_OK
Je ne comprends aussi pourquoi -f /etc/repmgr/10/repmgr.conf et transformé en -f ./repmgr.conf j'ai du faire un lien dans le home de mon user distant.
Merci
Pages : 1
