pgpool is a middleware that works between postgresql servers and postgresql clients

learn more… | top users | synonyms

0
votes
1answer
150 views

Pgpool configuration with Liferay cluster

I'm using a Liferay cluster connected to pgpool2 and when I run heavy user activity against the web servers I see a lot of exceptions regarding liferay unable to establish a connection to the DB. ...
0
votes
1answer
207 views

Proper management of PGPool II

Currently I have a site, with one Postgres database server. It is just for a select number of users (less than ten) but it needs the maximum uptime possible. I would like some kind of automatic ...
-1
votes
1answer
241 views

pgpool-ii show server as down, but server is running fine

I am using postgres 9.2 with streaming replication. I have 1 master DB and 2 standby DBs, it's hosted on amazon EC2, each has it's own server. On separate server i have pgpool(3.2.3) that does load ...
2
votes
3answers
1k views

PG pool failover leads to two independent masters with network failure

I've got two servers set up with PG Pool to create a HA setup for a webapp. PGPool and postgres run on both servers, using streaming replication from server 1 to server 2. The webapp on each machine ...
2
votes
1answer
1k views

pgpool2+streaming replication failover on only 2 servers?

I am trying to configure pgpool2 and postgresql 9.1 to handle failover. I currently have streaming replication running, and are using pgpool2 for read-only load balancing. I have 2 servers in my ...
1
vote
1answer
197 views

pgpool shm_exit(0)

I'm trying to set up pgpool-II on centos-5.4 For whatever reason pgpool-II fails silently when I try to start it up. I can't seem to find a log file in the default /tmp dir or in /var/log. Can anyone ...
0
votes
1answer
1k views

Synchronous Multimaster Replication postgresql pgpool 2

We would like to build a system of two Postgresql 8.4 servers, with pgpool 2 in front that will make all writes go to both systems. In the event of a failure on one of the nodes, it will degrade and ...