Setup: I have two instances of Postgres 9.0.3 and pg_pool 3.14 all running on the same Ibuntu (10.04) machine and am attempting to evaluate pgpool.
I can attach to pgpool using
psql -p <pgpool port> but only when the
pgpool.conf file has replication mode = false. If I set the replication mode = true then I see the log file generate the connection failure error on
/tmp.s.PGSQL.0 when I attempt the psql connection to pgpool's port.
After more exploration I would note that the additional error messages in the log indicate a failover handler is called, starting degeneration and shutdown secondary host(0) ????
After this if I do not restart pgool I can successfully connect (with replication mode = true) but I do not see any load sharing of my selects between my servers. (I have the load_share variable also set to true.)
What I am attempting to do is have have my insert/update statements replicated across my pool of servers and my selects to be load shared. Seem to be following the suggested setup but I encounter the above error problem.