Hi All,
we are running many postgresql master/slave setups. The slaves are
initialised from a pg_basebackup from the master and are sync streaming
from the master. When we determine the master has failed, the slave is
promoted. Some time after that, the old master is again initialised with a
Hello Mr. Ishii,
we have attempted to create a selfcontained testcase, but have been
unsuccessful so far. We understand how pgpool acquires locks in theory,
but it seems that what we are seeing is different. We have summarized our
findings here: http://pastebin.com/9f6gjxLA
It seems that pgpoo
Hi All,
@ Tom
Thank you for your response. While working on your suggestions, we seem to
have found the cause of our problems.
@ Yugo
Thank you for your response. We are running pgpool in replication mode
with load balancing enabled. If you have further questions to aid in
debugging the situa
Hi All,
We have a setup where 2 JBoss (5.1) servers communicate with 1 instance of
PgPool (3.04), which again communicates with 2 Postgresql (8.4) servers.
The JBoss servers host some Java code for us and as part of that they run
some quartz jobs.
These jobs are triggered right after startup
