балансировщик нагрузки с использованием pgpool2 не работает, потоковая передача работает
Я новичок в кластеризации postgres, я пытаюсь заархивировать балансировщик нагрузки с помощью pgpool2, но он не работает, выполните следующие шаги,
Это узлы:
мастернода, т.е. первичный 192.168.100.130, резервный сервер 192.168.100.131pgpool 192.168.100.132
Шаги:
1. Installed postgresql-14 using below commands on all servers i.e. masternode, standbynode & pgpool.
2. Achived streaming on masternode and standby using below steps ;
Change in MasterNode :
changes in /etc/postgresql/14/main/postgres.conf
listen_addresses = '*'
port = 5432
wal_level = replica
archive_mode = on
archive_command = 'rysnc -a %0 /home/pg_wal_archive/%f'
changes in /etc/postgresql/14/main/pg_hba.conf
host all all 192.168.100.131 trust
Change in StanbyNode :
removed files from main directory
executed : pg_basebackup command.
Streaming is working file, database and tables created at masternode are replicating standby node.
3. Installed pgpool2 on pgpool server note. postgres-14 is already installed here
sudo apt install pgpool2
listen_addresses = '*'
port = 5432
socket_dir = '/var/run/postgresql'
listen_backlog_multiplier = 2
serialize_accept = off
reserved_connections = 0
backend_hostname0 = '192.168.100.130'
backend_port0 = 5432
backend_weight0 = 0
backend_data_directory0 = '/var/lib/pgsql/data'
backend_flag0 = 'DISALLOW_TO_FAILOVER'
backend_application_name0 = 'master'
# walsender's application_name, used for "show pool_nodes" command
backend_hostname1 = '192.168.100.131'
backend_port1 = 5432
backend_weight1 = 1
backend_data_directory1 = '/data1'
backend_flag1 = 'DISALLOW_TO_FAILOVER'
backend_application_name1 = 'slave'
log_destination = 'syslog'
load_balance_mode = on
ignore_leading_white_space = on
master_slave_mode = on
master_slave_sub_mode = 'stream'
sr_check_period = 5
sr_check_user = 'monitor'
sr_check_password = 'Monitor@123'
sr_check_database = 'postgres'
delay_threshold = 0
Please check if I am missing something or do I missed any steps. Please note streaming is working as expected.
спасибо паван