Re: [pgsql-es-ayuda] Status DISCARD ALL

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