Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I'm facing problem with my pgpool setup. Currently, this is my requirement based on the pgpool documentation here :

Server A : Install with PostgreSQL database. Run as primary server

Server B : Install with PostgreSQL database. Run as secondary server

Server C : Install with Pgpool and PgpoolAdmin. Run as web server.

The problem starts when I'm accessing the pgpoolAdmin through apache webserver.

pgpool Status

Both of the PostgreSQL databases is running as primary server. It suppose to run one as standby and the other as primary when the fail over occur. Maybe I've messed up something when configuring this set up, but I don't know what is it. Can someone help me with this?

EDIT : Below is my pgpool.conf file

master_slave_mode = on                                      
master_slave_sub_mode = 'stream'   
wd_life_point = 3    
wd_lifecheck_query = 'SELECT 1'   
backend_socket_dir = '/tmp'    
backend_hostname0 = ''   
backend_port0 = 5432   
backend_weight0 = 1    
backend_data_directory0 = '/usr/local/pgsql/data'   
backend_flag0= 'ALLOW_TO_FAILOVER'    
backend_hostname1 = ''    
backend_port1 = 5432   
backend_weight1 = 1   
backend_data_directory1 = '/usr/local/pgsql/data'   
backend_flag1= 'ALLOW_TO_FAILOVER'
share|improve this question
Now what have you specified in the config? Sounds like you feel a discrepancy between it and the status report above. –  dezso Nov 8 '12 at 5:40
@dezso what do you want to see?is it the posgresql conf or the pgpool conf?i can put it in my post –  user119720 Nov 8 '12 at 6:35
We need the pgpool conf, I think. –  dezso Nov 8 '12 at 7:28
i've already edit.see my post above –  user119720 Nov 8 '12 at 8:21
@dezso i've see you have edited my post.so can you tell me what is the problem with my setup? –  user119720 Nov 12 '12 at 3:52

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.