Take the 2-minute tour ×
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. It's 100% free, no registration required.

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?

share|improve this question
    
This is perhaps a simple cockpit error. I installed pgpool 3.4.1 and should have installed pgpool II 3.1 –  Dave Oct 21 '11 at 18:16
add comment

migrated from stackoverflow.com Oct 24 '11 at 13:49

This question came from our site for professional and enthusiast programmers.

1 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.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.