Hung backends

Schmidt, Peter <peter.schmidt@prismedia.com>

From: "Schmidt, Peter" <peter.schmidt@prismedia.com>
To: "'pgsql-general@postgresql.org'" <pgsql-general@postgresql.org>
Date: 2000-11-17T18:38:37Z
Lists: pgsql-general
Hi,

I'm new to PostgreSQL and have been tasked with determining the cause of
hung processes on FreeBSD after the frontend app dies. Eventually we run out
of connections when hung processes = MAXBACKENDS.

ps -cl -U postgres returns:

UID   PID  PPID CPU PRI NI   VSZ  RSS WCHAN  STAT  TT       TIME COMMAND
  500  1395     1   0   2  0  4040 2380 select Ss    ??    0:01.17 postgres
  500  2255  1395   0   2  0  4384 2984 sbwait I     ??    0:00.01 postgres
  500  2256  1395   0   2  0  4384 2984 sbwait I     ??    0:00.01 postgres
  500  2257  1395   0   2  0  4384 2984 sbwait I     ??    0:00.01 postgres
  500  2258  1395   0   2  0  4384 2984 sbwait I     ??    0:00.01 postgres
  500  2259  1395   0   2  0  4384 2984 sbwait I     ??    0:00.01 postgres
  ...

The java frontend I'm using to test this scenario makes multiple connections
and crashes(unhandled exception) before disconnecting. This appears to leave
one "postgres" proccess for each connection. Can anyone point me in the
right direction?
SELECT version(); ->  PostgreSQL 7.0.2 on i386-unknown-freebsdelf4.0

Thanks for any advice.
Peter Schmidt