[Pgpool-general] Client application loses connection to pgpool during failover

[su]

Vanessa <vpao at ...> writes:

> 
> Vanessa <vpao at ...> writes:
> 
> > 
> > Hello,
> > I have pgpool-II installed on one VM and I have PostgreSQL 9.0.2 installed 
on
> > two other VMs. pgpool is managing the two PostgreSQL servers as a cluster. 
I
> > also have a client application connected to pgpool. I notice when I bring 
down
> > the primary database and pgpool is in the process of promoting the 
secondary
> 
> Hi,
> Just checking to see if anyone might have insight into this. 
> 
> Thanks in advance,
> Vanessa Pao
> 


Hi Vanessa,

We have also ended up having a FATAL issue stating "too many clients already", 
which probably required pgpool2 to be configured. But after configuring, it 
was even worse. Did you get your problem sorted out? Please reply if yes with 
the solution.

Sajan