Re: Configuration Parameters

On Fri, Mar 23, 2001 at 06:00:44PM -0600, Richard Ehrlich wrote:
> I am setting up a web-based app on Apache, JServ and PostgreSQL 7.0 running
> on freeBSD. Occasionally I get a "Too many clients" exception, which I can
> work around by rebooting Apache. I understand this may be a configuration
> problem, but I am not sure how to proceed.
> If I expect about 50 concurrent full-time users, what are appropriate -N
> and -B values for the postmaster? What would be appropriate values for
> SHMMAX, SEMMNS, SEMMNI, NPROC, MAXUPRC, NFILE and NINODE? Are there any
> other configuration parameters that I need to worry about?
> What is the mechanism for shutting down postmaster instances? Should my
> Java servlets do this explicitly?

Either close the connection explicity:
connection.close();

or use connection pooling. 'Core Servlets and JavaServer Pages' has a
chapter on this.

tom