Hi,
I am not sure your error msg is exact.
If Postgres say: too many clients ...
means current postmaster cannot take more client(or
say session), you need shut down current postmaster
and re_start a new postmaster with -N dd
where dd is the number of client you need,
by defualt dd=32, max dd=1024
Hope it helps.
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 already'. We have
> recently installed the database version 7.0.3. We were
> able to move our data successfully from SQL*Server.
> Calls to database are made from our application
> written in Java, JSP. Can anyone help
> me with this?
>
> Thanks,
>
> Subra
> Chief Technical Officer
> Aavanor Systems
> _________________________________________________________________________
>
>
> __________________________________________________
> Do You Yahoo!?
> Get email at your own domain with Yahoo! Mail.
> http://personal.mail.yahoo.com/
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>