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@postgresql.org
[mailto:pgsql-general-owner@postgresql.org]On Behalf Of Jose Manuel
Lorenzo Lopez
Sent: Friday, February 02, 2001 10:21 AM
To: Belcher, Jim
Cc: pgsql-general@postgresql.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.lorenzo-lopez@conti.de                    **
**********************************************************************