Sabes, este es un Foro en español y eres de Venezuela, por que nos
escribes en Ingles ?
On 2/19/2016 3:39 PM, ALEXANDER JOSE wrote:
Our platform consists of two servers with database postgresql v9.3, v3.3
pgpool for high availability on debian OS v7, and we have many
connections webserver servers. The problem is presented when down two
servers in weblogic that are clustered, and the pgpool connection status
discard all remain, making it impossible to back up both servers
WebLogic, to solve it we must lower the pgpool of each nodes so that
sessions that were to discard all canceled status and weblogic can start
and open connections without error.
We would like to know if there are any configuration parameter that can
kill pgpool sessions remaining discard all status.
If your problem is Zombie process, the only way is performing "kill -9"
Perhaps, the following link may help.
http://stackoverflow.com/questions/13236160/is-there-a-timeout-for-idle-postgresql-connections
http://www.pgpool.net/mantisbt/view.php?id=45
BTW, what Weblogic documentation say about postgresql-pgpool-WebLogic ?
Alexander Angel
DAB Postgresql
Venezuela
--
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
