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. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm facing a 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 web server.

pgpool Status

Both of the PostgreSQL databases are running as primary servers. It is supposed to run one as standby and the other as primary, for when failover occurs. Maybe I've messed up something when configuring this set up, but I don't know what it is. 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 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.