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.
Comments?
Best Answer
AS per my comment this ended up being a misunderstanding between pgppool and pgpool-II being separate open source projects. When correctly using pgpoolII and it's documentation this error was not a problem.