- 论坛徽章:
- 71
|
下面是pgpool.conf的部分配置:
使用psql -p 5999,连接发现只联backend_hostname0 ,没有backend_hostname1;把backend_hostname0 停掉,再连,发现日志只试图去联backend_hostname0
- # connections
- listen_addresses = '*'
- # Port number for pgpool
- port = 5999
- #set pgpool2 hostname
- pgpool2_hostname = '192.168.8.200'
- # system DB info
- system_db_hostname = 'localhost'
- system_db_port = 5432
- system_db_dbname = 'pgpool'
- system_db_schema = 'pgpool_catalog'
- system_db_user = 'postgres'
- system_db_password = '123456'
- # backend_hostname, backend_port, backend_weight
- # here are examples
- backend_hostname0 = 'localhost'
- backend_port0 = 5455
- ackend_weight0 = 1
- backend_data_directory0 = '/usr/local/postgres/data1'
- backend_hostname1 = '192.168.8.200'
- backend_port1 = 5555
- backend_weight1 = 1
- backend_data_directory1 = '/usr/local/postgres/data2'
复制代码 |
|