RE: Too many clients.

you also want to make sure that your application is releasing the
connections. if you never release a connection, it won't matter how high
you set the connection parameter...

-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org]On Behalf Of Jose Manuel
Lorenzo Lopez
Sent: Friday, February 02, 2001 10:21 AM
To: Belcher, Jim
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Too many clients.

"Belcher, Jim" schrieb:
>
> In 7.0 am i supposed to set the number of users or something.
>
> After running for awhile and try to use psql, psql complains about
> too many clients. After that, clients cannot connect either.

Hello Jim,

sounds like this is answered in a FAQ! Please check this:
http://www.postgresql.org/docs/faq-english.html#3.9

Best Regards,

José Manuel Lorenzo López

--
**********************************************************************
** José Manuel Lorenzo López **
** **
** ICA Informationssysteme Consulting & Anwendungsgesellschaft mbH **
** Dept. SAP Basis R/3 VBue **
** **
** phone: (+49511) 938-2961 **
** fax : (+49511) 938-2270 **
** e-mail to: jose-manuel(dot)lorenzo-lopez(at)conti(dot)de **
**********************************************************************