can't connect postgresql server. max connection exceeded.

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.

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