Re: Sorry, too many clients already

By default, one postmaster allows 32 clients to connect at same time,
max is 1024.

1. check your processes under the postgres, kill the junky proccesses.
2. re_start your postmaster with -N=?? (>32)
see your man page of postmaster.


Jie LIANG

St. Bernard Software

10350 Science Center Drive
Suite 100, San Diego, CA 92121
Office:(858)320-4873

jliang@ipinc.com
www.stbernard.com
www.ipinc.com

On Fri, 23 Mar 2001, Subra Radhakrishnan wrote:

> Hi All,
>
> We are getting an error every now and then in
> PostgreSQL saying 'Sorry, too many
> clients already'. We have recently installed the
> database version 7.0.3. Calls to
> database are made from our application written in
> Java, JSP. Can anyone help
> me with this?
>
> Thanks,
>
> Subra
> _________________________________________________________________________
>
>
> __________________________________________________
> Do You Yahoo!?
> Get email at your own domain with Yahoo! Mail.
> http://personal.mail.yahoo.com/
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>