Hello
I have configuration pgpool and work loadbalancing and watchdog. I have replication type streaming too but when I perform command show pool_nodes I have empty columns replication_sta te and replication_syn c_state while when I have replication and it working?
Why i have empty columns? Might it is problem and because I can't switch database (do pcp_promote_nod e)
User Profile
Collapse
-
Postgresql12 and pgpool2
Hello
I have all configuration in pgpool2, Things such as load balancing and watchdog work but when I want execute command pcp_recovery_no de. I received in log:
DETAIL: starting recovery command: "SELECT pgpool_recovery ('recovery_1st_ stage', '192.168.164.20 2', '/var/lib/pgsql/12/data', '5432', 1, '5432')"
LOG: executing recovery
DETAIL: disabling statement_timeo ut
ERROR: executing recovery, execution...
No activity results to display
Show More