Re: [GENERAL] removing idle connections

2004-10-19 Thread Gaetano Mendola
Josh Close wrote: Is there a way to remove idle connections? My postgres server is getting serveral hundred idle connections. It's due to a postgres .NET provider not closing the connections properly. I don't want to kill them all, or restart postgres everytime the connections go crazy. I do not th

Re: [GENERAL] removing idle connections

2004-10-19 Thread Gary Doades
On 19 Oct 2004 at 13:32, Josh Close wrote: > The provider is corelabs. The programmer that wrote the code says he's > closing the connections, but they aren't actually closing. > > Any ideas? Or better yet, do you know of a good postgres .net provider? > Hmm, I've had lots of problems with the

Re: [GENERAL] removing idle connections

2004-10-19 Thread Josh Close
On Tue, 19 Oct 2004 19:24:23 +0100, Gary Doades <[EMAIL PROTECTED]> wrote: > I would have though it would be better to fix the client application. If the > app is not closing connections then you may be leaking handles and > memory. > > What .NET provider is this? Are you sure it is not just norma

Re: [GENERAL] removing idle connections

2004-10-19 Thread Gary Doades
On 19 Oct 2004 at 13:00, Josh Close wrote: > Is there a way to remove idle connections? My postgres server is > getting serveral hundred idle connections. It's due to a postgres .NET > provider not closing the connections properly. I don't want to kill > them all, or restart postgres everytime the

[GENERAL] removing idle connections

2004-10-19 Thread Josh Close
Is there a way to remove idle connections? My postgres server is getting serveral hundred idle connections. It's due to a postgres .NET provider not closing the connections properly. I don't want to kill them all, or restart postgres everytime the connections go crazy. -Josh -