Re: can't connect postgresql server. max connection

From: Joel Burton <joel(at)joelburton(dot)com>
To: "Youn-Oh, Jung" <yojung(at)grtg(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: can't connect postgresql server. max connection
Date: 2001-10-19 20:47:16
Message-ID: Pine.LNX.4.30.0110191646550.22474-100000@temp.joelburton.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)joelburton(dot)com | joelburton.com | aim: wjoelburton
Independent Knowledge Management Consultant

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-10-19 21:56:37 Re: DEBUG: StartTransactionCommand
Previous Message Joel Burton 2001-10-19 20:40:58 Re: Authentication FAQ or Howto?