From: | Moises Alberto Lindo Gutarra <mlindo(at)gmail(dot)com> |
---|---|
To: | "Venki(at)insoft(dot)com" <Venki(at)insoft(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Too many clients connected |
Date: | 2005-10-10 16:00:14 |
Message-ID: | 5db591c00510100900k2a271fa6k@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
first of all, your clients are closing connections??
yo should use a pool connection.
2005/10/10, Venki(at)insoft(dot)com <Venki(at)insoft(dot)com>:
>
>
>
>
> Hi All,
> I am sorry if this was already discussed. I am new to the world of
> postgressql and was experincing a problem for which I need help of an
> expert in this lists.
> We have devloped a site(asp.net 1.1) for which we have used postgresql 7.4
> as the backend database. When the number of connections increases we are
> getting an error "Too many clients are connected" we then adjusted the
> number of connections from the initial value of 30+ to 200 it get solved
> initially but we are experincing the same problem again. Before adjust the
> connection settings I would like some one with answers to the following
> questions.
> 1. How does postgresql handles database connections?
> 2. Under what situations does this error "Too many clients connected" is
> thrown?
> 3. Should we increase the max connection settings to say 1000 if yes what
> about the PC configuration that is needed for it. We are currently running
> the postgresql in a linux box with 1 GB ram and 2GHZ xeon processor.
> 4. is it advisable to upgrade postgresql to 8.0?? will it solve this error
> once and for all.
>
> Thanks in advance
>
> regards
> venki
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org
>
--
Atte
Moises Alberto Lindo Gutarra
Consultor y Desarrollador Java / Open Source
TUMI Solutions SAC
Tel: +51.13481104
Cel: +51.197366260
MSN : mlindo(at)tumisolutions(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Csaba Nagy | 2005-10-10 16:01:52 | Re: Too many clients connected |
Previous Message | Venki | 2005-10-10 15:59:55 | Too many clients connected |