Thanks Muhammad !
Here i uploaded details.
Thanks
Vijay
On Wed, May 29, 2024 at 10:58 AM Muhammad Imtiaz <imtiaz.m@xxxxxxxxxxx> 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 ImtiazOn Tue, 28 May 2024 at 23:01, Adrian Klaver <adrian.klaver@xxxxxxxxxxx> 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.klaver@xxxxxxxxxxx
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
Attachment:
Leader_pgpool.log
Description: Binary data
Attachment:
Standby1_pgpool.log
Description: Binary data
Attachment:
Standby_pgpool.log
Description: Binary data
