Lingering Backend Processes

From: "Arthur M(dot) Kang" <arthur(at)levelogic(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Lingering Backend Processes
Date: 2000-06-28 16:32:29
Message-ID: 395A289D.D4EB24A6@levelogic.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

If a postgres connection dies without implicitly disconnecting from the
database, it seems that the backend processes hangs around
indefinitely. Does anyone know of a way to get around this??

I'm using Postgres 7.0.2 and ApacheDBI to connected. If I start the
web server with 10 servers, there is immediately 10 postgres processes.
If I HUP the web server, there become 20 postgres processes. If I stop
and then start the web server, the number of postgres processes will
remain the same.

Can anyone tell me if I'm doing something incorrectly, or if there is
another way to periodically kill of these processes? I've noticed that
even killing the postmaster processes will no kill of the backend
processes.

Thanks.

Arthur

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Blakeley 2000-06-28 17:48:50 anyone heard of "recall"?
Previous Message Ted Nolan SRI Augusta GA 2000-06-28 16:25:32 Re: DateTime fields