[pgpool-general: 7401] All nodes are the standby

[Luís Alves]

Hi

Mu cluster have 2 nodes and currently I'm getting:

find_primary_node: standby node is 1
find_primary_node: standby node is 0

I'm trying to issue detach or promote commands but I get this:

-bash-4.2$ pcp_detach_node -w -h 10.230.4.148 -p 9898 -U pgpool -g  -n 1
ERROR: connection to host "10.230.4.148" failed with error "Connection
refused"
-bash-4.2$  pcp_promote_node -w -h 10.230.4.148 -p 9898 -U pgpool -g  -n 0
ERROR: connection to host "10.230.4.148" failed with error "Connection
refused"

Any idea how I can mark one as primary?

I'm running with the -D flag: /usr/bin/pgpool -f /etc/pgpool-II/pgpool.conf
-D -n

Regards
Luís Alves
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20210119/8ce8e068/attachment.htm>