Postgres Pro
Downloads
Home   >   mailing lists

Re: Not Enough Connections - Mailing list pgsql-general

From Tom Lane
Subject Re: Not Enough Connections
Date
Msg-id 19552.1047326372@sss.pgh.pa.us
Whole thread Raw
In response to Not Enough Connections  (Hunter Hillegas <lists@lastonepicked.com>)
Responses Re: Not Enough Connections  (Lonni J Friedman <lfriedman@vasoftware.com>)
List pgsql-general
Tree view 
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.

            regards, tom lane

pgsql-general by date:

Previous
From: "Ben Ramsey"
Date:
Subject: Re: Problems with pg_dump
Next
From: Lonni J Friedman
Date:
Subject: Re: Not Enough Connections