pgpool只能联一个服务器

zhaopingzi

下面是pgpool.conf的部分配置：
使用psql -p 5999,连接发现只联backend_hostname0 ，没有backend_hostname1；把backend_hostname0 停掉，再连，发现日志只试图去联backend_hostname0

1. 
   
2. # connections
   
3. listen_addresses = '*'
   
4. 
   
5. 
   
6. # Port number for pgpool
   
7. port = 5999
   
8. #set pgpool2 hostname
   
9. pgpool2_hostname = '192.168.8.200'
   
10. # system DB info
    
11. system_db_hostname = 'localhost'
    
12. system_db_port = 5432
    
13. system_db_dbname = 'pgpool'
    
14. system_db_schema = 'pgpool_catalog'
    
15. system_db_user = 'postgres'
    
16. system_db_password = '123456'
    
17. 
    
18. # backend_hostname, backend_port, backend_weight
    
19. # here are examples
    
20. backend_hostname0 = 'localhost'
    
21. backend_port0 = 5455
    
22. ackend_weight0 = 1
    
23. backend_data_directory0 = '/usr/local/postgres/data1'
    
24. 
    
25. backend_hostname1 = '192.168.8.200'
    
26. backend_port1 = 5555
    
27. backend_weight1 = 1
    
28. backend_data_directory1 = '/usr/local/postgres/data2'
    

复制代码