From: Horacio Miranda <hmiranda@gmail.com>
To: ALEXANDER JOSE <aangelj@hotmail.com>
To: postgres admin <pgsql-admin@postgresql.org>
To: Postgres Español <pgsql-es-ayuda@postgresql.org>
Subject: Re: [pgsql-es-ayuda] Status DISCARD ALL
Date: Fri, 19 Feb 2016 16:16:30 +1300
Message-ID: <56C6890E.40803@gmail.com> (raw)
In-Reply-To: <COL129-W8021542A62B62033C91C9FA5A00@phx.gbl>
References: <COL129-W8021542A62B62033C91C9FA5A00@phx.gbl>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
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-connectionshttp://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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: hmiranda@gmail.com, aangelj@hotmail.com, pgsql-es-ayuda@postgresql.org
Subject: Re: [pgsql-es-ayuda] Status DISCARD ALL
In-Reply-To: <56C6890E.40803@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox