Re: Idle connections - Too many clients connected already

On Thursday 22 January 2004 06:57, Philippe Lang wrote:
> Hello,
>
> After using Postgresql for a while, through ODBC / MS Access, I'm not
> able to connect to the server anymore. The server reports "Too many
> clients connected already".
[snip]
> Is there a way to avoid that? I cannot certifiy that clients will always
> close their connexions in a clean way. So, is the server able to check
> if clients are still alive, and close their connection if it's not the
> case?

You can set a timeout for the ODBC on each client. I can't remember if this is
in the odbc driver settings panel or where. Worst case, it's a registry
setting. That should do what you want.

--
  Richard Huxton
  Archonet Ltd