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 **
**********************************************************************