Re: can't connect postgresql server. max connection exceeded. - Mailing list pgsql-general

From Steve Brett
Subject Re: can't connect postgresql server. max connection exceeded.
Date
Msg-id 9qoo5v$1dfh$1@news.tht.net
Whole thread Raw
In response to can't connect postgresql server. max connection exceeded.  ("Youn-Oh, Jung" <yojung@grtg.com>)
List pgsql-general
have a look at the flag settings for postmaster and set N={number of
connections needed} i think ...

Steve

"Youn-Oh, Jung" <yojung@grtg.com> wrote in message
news:9qod8l$1b3u$1@news.tht.net...
> Hello. I have a question about max connection.
>
> i use postgreSQL 7.0.3 and up to now i use well.
>
> but, this time i encountered the max connection problem.
>
> my default max connection value is 32.
>
> that is, if 32 connections are established, no other connection can't be
> established..
>
> then once 32 connections are established, processes that contain
postgresql
> connection are not operational. 32 processes have connections are not
ended.
> so system can't create any new connection to postgreSQL.
>
> why this situation do occur?
>
> have any suggestion that figure out this problem???
>
>



pgsql-general by date:

Previous
From: "DOMA"
Date:
Subject: Stored procedure
Next
From: "Lark"
Date:
Subject: ecpg: How to connect to host w. user:password?