| From: | Lonni J Friedman <lfriedman(at)vasoftware(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Hunter Hillegas <lists(at)lastonepicked(dot)com>, PostgreSQL <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Not Enough Connections |
| Date: | 2003-03-10 20:02:15 |
| Message-ID: | Pine.LNX.4.44.0303101200540.8716-100000@beefcake.hdqt.vasoftware.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, 10 Mar 2003, Tom Lane wrote:
> Hunter Hillegas <lists(at)lastonepicked(dot)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?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2003-03-10 20:10:55 | Re: [NOVICE] General Performance questions |
| Previous Message | Tom Lane | 2003-03-10 19:59:32 | Re: Not Enough Connections |