[pgpool-general: 7643] empty replication_state and replication_sync_state in SHOW POOL_NODES
Francesco Mazzi
fmazzi at comune.genova.it
Thu Jul 15 18:43:50 JST 2021
Hello, replication is working, if I execute "select * from pg_stat_replication;" on master node I see state and sync_state, but with SHOW POOL_NODES, replication_state and replication_sync_state are empty.
I set the backend_application_name for every node in pgpool.conf, which could be the issue?
This is pgpool.conf backend settings:
# - Backend Connection Settings -
backend_hostname0 = 'vm-lxpgresc1'
# Host name or IP address to connect to for backend 0
backend_port0 = 5432
# Port number for backend 0
backend_weight0 = 1
# Weight for backend 0 (only in load balancing mode)
backend_data_directory0 = '/var/lib/pgsql/12/data'
# Data directory for backend 0
backend_flag0 = 'ALLOW_TO_FAILOVER'
# Controls various backend behavior
# ALLOW_TO_FAILOVER, DISALLOW_TO_FAILOVER
# or ALWAYS_PRIMARY
backend_application_name0 = 'vm-lxpgresc1'
# walsender's application_name, used for "show pool_nodes" command
backend_hostname1 = 'vm-lxpgresc2'
# Host name or IP address to connect to for backend 0
backend_port1 = 5432
# Port number for backend 0
backend_weight1 = 1
# Weight for backend 0 (only in load balancing mode)
backend_data_directory1 = '/var/lib/pgsql/12/data'
# Data directory for backend 0
backend_flag1 = 'ALLOW_TO_FAILOVER'
# Controls various backend behavior
# ALLOW_TO_FAILOVER, DISALLOW_TO_FAILOVER
# or ALWAYS_PRIMARY
backend_application_name1 = 'vm-lxpgresc2'
# walsender's application_name, used for "show pool_nodes" command
backend_hostname2 = 'vm-lxpgresc3'
# Host name or IP address to connect to for backend 0
backend_port2 = 5432
# Port number for backend 0
backend_weight2 = 1
# Weight for backend 0 (only in load balancing mode)
backend_data_directory2 = '/var/lib/pgsql/12/data'
# Data directory for backend 0
backend_flag2 = 'ALLOW_TO_FAILOVER'
# Controls various backend behavior
# ALLOW_TO_FAILOVER, DISALLOW_TO_FAILOVER
# or ALWAYS_PRIMARY
backend_application_name2 = 'vm-lxpgresc3'
# walsender's application_name, used for "show pool_nodes" command
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20210715/31257c81/attachment.htm>
More information about the pgpool-general
mailing list