Client connection lost; still in the task list

From: "Didier Gasser-Morlay" <didiergm(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Client connection lost; still in the task list
Date: 2008-04-22 17:18:00
Message-ID: 608b66ce0804221018vc410e1aleafefe255187b238@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hello,

We've just put into production with our main application which we
ported from MSSQLserver to PostgreSQL;

We are overall very pleased with PostgreSQL speed and stability are fantastic.

We have one user which PC keeps freezing and despite rebooting the
computer several times since this morning I can find more than 24
connections for this user when there should be at most 2. So we are
experiencing 'too many users connected' errors

So my question is what makes PostgreSQL realise that a connection is
dead ? when will it drop it and free the connection ?

Doing a ps ax I see many connection related to that IP address,
can I safely kill the processes which are obviously redundant ? if
yes, which signal to send ? (I do not want to kill the postmaster,
just the connection).

Going forward is there a good way of doing this ?

We are running on Centos 4, PostgreSQL 8.3

thanks in advance for your input

Didier

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2008-04-22 17:29:28 Re: Client connection lost; still in the task list
Previous Message Nils Zierath 2008-04-22 12:46:03 Re: Remote / network connection fails