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.
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 = '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'