Thanks Muhammad ! Here i uploaded details.
Thanks Vijay On Wed, May 29, 2024 at 10:58 AM Muhammad Imtiaz <imtia...@bitnine.net> wrote: > Hi, > > Can you please provide the Pgpool logs? Additionally, in a distributed > environment, ensure that Pgpool is properly configured. You can follow > these documented steps to set up the Pgpool configurations > pgpool.conf,pcp.conf and pool_hba.conf . > > Regards, > Muhammad Imtiaz > > On Tue, 28 May 2024 at 23:01, Adrian Klaver <adrian.kla...@aklaver.com> > wrote: > >> >> >> On 5/28/24 1:31 AM, vijay patil wrote: >> > >> > HI Team, >> > >> > "I'm encountering challenges while configuring Pgpool with high >> > availability. The initial setup is completed, and Pgpool is operational >> > on a single node, functioning without issues. However, upon attempting >> > to start Pgpool on any additional nodes, particularly node 2, it >> becomes >> > immediately unreachable. >> >> And how we are supposed to arrive at an answer with essentially no >> information provided? >> >> Need: >> >> 1) Configuration for initial setup. >> >> 2) A more detailed explanation of what "... upon attempting >> to start Pgpool on any additional nodes" means? Include configuration >> changes. >> >> 3) The error messages. >> >> 4) Where the nodes are located? >> >> >> > >> > I'm seeking assistance to address this issue. My setup consists of >> three >> > nodes, each hosting both PostgreSQL and Pgpool services." >> > >> > >> > Thanks >> > >> > Vijay >> > >> >> -- >> Adrian Klaver >> adrian.kla...@aklaver.com >> >> >>
Pgpool.conf == listen_addresses = '*' port = 9999 pcp_listen_addresses = '*' backend_hostname0 = 'ha0001' backend_port0 = 5432 backend_weight0 = 1 backend_hostname1 = 'ha0002' backend_port1 = 5432 backend_weight1 = 1 backend_hostname2 = 'ha0003' backend_port2 = 5432 backend_weight2 = 1 load_balance_mode = 'on' master_slave_mode = 'on' master_slave_sub_mode = 'stream' sr_check_period = 10 sr_check_user = 'monitor' sr_check_password = 'Monitor@321' sr_check_database = 'monitor' delay_threshold = 10240 allow_clear_text_frontend_auth = 'on' pid_file = '/var/run/pgpool/pgpool.pid' logging_collector = on log_directory = '/u01/app/admin/Data/PG_LOGS' log_filename = 'pgpool.log' num_init_children = 30 enable_pool_hba = on pool_passwd = '/usr/local/etc/pool_passwd' health_check_period = 30 health_check_timeout = 20 health_check_user = 'pgbigboss' health_check_password = 'pgbigboss' health_check_database = 'postgres' health_check_max_retries = 3 health_check_retry_delay = 1 connect_timeout = 10000 statement_level_load_balance = on use_watchdog = on delegate_ip = '10.127.1.18' if_up_cmd = '/sbin/ip addr add $_IP_$/24 dev eth0 label eth0:1' if_down_cmd = '/sbin/ip addr del $_IP_$/24 dev eth0' arping_cmd = '/usr/sbin/arping -U $_IP_$ -w 1 -I eth0 -c 3' hostname0 = 'ha0001' wd_port0 = 9000 pgpool_port0 = 9999 hostname1 = 'ha0002' wd_port1 = 9000 pgpool_port1 = 9999 hostname2 = 'ha0003' wd_port2 = 9000 pgpool_port2 = 9999 wd_lifecheck_method = 'heartbeat' wd_interval = 10 heartbeat_hostname0 = 'ha0001' heartbeat_port0 = 9694 heartbeat_device0 = '' heartbeat_hostname1 = 'ha0002' heartbeat_port1 = 9694 heartbeat_device1 = '' heartbeat_hostname2 = 'ha0003' heartbeat_port2 = 9694 heartbeat_device2 = '' wd_heartbeat_keepalive = 2 wd_heartbeat_deadtime = 30 #trusted_servers = '' trusted_server_command = 'ping -q -c3 %h' backend_clustering_mode = 'streaming_replication' [root@staging-ha0001 etc]# ################################################# pgpool_node_id [root@staging-ha0001 etc]# cat pgpool_node_id 0 [root@staging-ha0001 etc]# ######################### pool_hba.conf local all all trust # IPv4 local connections: host all all 127.0.0.1/32 trust host all all ::1/128 trust host all all 10.127.1.10/32 trust host all all 10.127.1.11/32 trust host all all 10.127.1.13/32 trust ######################## pcp.conf pgbigboss:66c7766130b3cf99e9ed3fde1a9f59de
Leader_pgpool.log
Description: Binary data
Standby1_pgpool.log
Description: Binary data
Standby_pgpool.log
Description: Binary data
