Thread: can't connect postgresql server. max connection exceeded.

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???

On Fri, 19 Oct 2001, Youn-Oh, Jung wrote:

> 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???
>

'man postmaster' will give command-line switches to change # of
connections allowed.

--

Joel BURTON  |  joel@joelburton.com  |  joelburton.com  |  aim: wjoelburton
Independent Knowledge Management Consultant

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???
>
>