Re: Not Enough Connections - Mailing list pgsql-general

From Lonni J Friedman
Subject Re: Not Enough Connections
Date
Msg-id Pine.LNX.4.44.0303101200540.8716-100000@beefcake.hdqt.vasoftware.com
Whole thread Raw
In response to Re: Not Enough Connections  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Not Enough Connections  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Mon, 10 Mar 2003, Tom Lane wrote:
> Hunter Hillegas <lists@lastonepicked.com> writes:
> > The postmaster was originally started with the default settings. Since then
> > the limit has been upped to 200 connections (along with some other stuff
> > like shared mem stuff) and I did a pg_ctl reload to get the new settings in
> > there...
>
> pg_ctl reload does not suffice to alter max_connections; that can only
> be set at postmaster startup.  Shut down and restart.

I read somewhere a while ago that the upper value of max_connections is
hardcoded at compile time, and that it can only be reduced via the
configuration file.  Is this true, or did i misunderstand?


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Not Enough Connections
Next
From: Tom Lane
Date:
Subject: Re: [NOVICE] General Performance questions