[pgpool-general: 8307] Problems with pcp_recovery_node
Jon SCHEWE
jon.schewe at raytheon.com
Wed Jul 6 06:49:40 JST 2022
I used pg_ctl to take down psql-dev-01 and it showed a proper down state in the output of "show pool_nodes".
I then tried to bring it back online and got an error about the primary server not being able to be recovered.
However the primary server is psql-dev-03.
What am I missing here?
Using pgpool 4.3.2 with postgresql 13.
[jschewe-adm at psql-dev-01 ~]$ pcp_recovery_node -h psql.mgmt.bbn.com -p 9897 -U pgpool -n 0
Password:
ERROR: process recovery request failed
DETAIL: primary server cannot be recovered by online recovery.
[jschewe-adm at psql-dev-01 ~]$ psql -h psql-dev.mgmt.bbn.com -p 9898 -U pgpool template1
Password for user pgpool:
psql (13.7)
SSL connection (protocol: TLSv1.3, cipher: TLS_AES_256_GCM_SHA384, bits: 256, compression: off)
Type "help" for help.
template1=> show pool_nodes;
node_id | hostname | port | status | pg_status | lb_weight | role | pg_role | select_cnt | load_balance_node | replication_delay | replication_state | replication_sync_state | last_status_change
---------+--------------------------+------+--------+-----------+-----------+---------+---------+------------+-------------------+-------------------+-------------------+------------------------+---------------------
0 | psql-dev-01.mgmt.bbn.com | 5432 | down | down | 0.333333 | standby | unknown | 0 | false | 0 | | | 2022-07-05 17:33:12
1 | psql-dev-02.mgmt.bbn.com | 5432 | up | up | 0.333333 | standby | standby | 0 | false | 0 | streaming | sync | 2022-07-01 16:37:19
2 | psql-dev-03.mgmt.bbn.com | 5432 | up | up | 0.333333 | primary | primary | 6 | true | 0 | | | 2022-07-01 12:41:51
(3 rows)
Jon
More information about the pgpool-general
mailing list