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.
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 = '192.168.1.134' backend_port0 = 5432 backend_weight0 = 1 backend_data_directory0 = '/usr/local/pgsql/data' backend_flag0= 'ALLOW_TO_FAILOVER' backend_hostname1 = '192.168.1.136' backend_port1 = 5432 backend_weight1 = 1 backend_data_directory1 = '/usr/local/pgsql/data' backend_flag1= 'ALLOW_TO_FAILOVER'