| From: | Thomas F(dot)O'Connell <tfo(at)sitening(dot)com> |
|---|---|
| To: | fred <fred(at)elma(dot)fr> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Limited to 100 connections |
| Date: | 2005-04-11 21:56:42 |
| Message-ID: | 16fdb7fc4e8c15ab40acc2540143fe4c@sitening.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
max_connections is a setting that can only be set at server start. Are
you restarting postgres after you change the setting in
postgresql.conf?
-tfo
--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
Strategic Open Source: Open Your i™
http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-260-0005
On Apr 7, 2005, at 5:52 PM, fred wrote:
> Hi,
> I'm using Postgres on MacOS X 10.3 and I'm limited to 100 connections.
> In the postgres.conf, I set max_connections to 300, but I'm always
> limited to 100 connections.
> I also increased the SHM_MAX to 400 Megs
>
> I connect to my database using PHP scripts and pg_pconnect.
>
> If anyone got an idea, I'll take it
>
> Thanks
>
> Fred
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas F.O'Connell | 2005-04-11 22:43:52 | Re: Pg_autovacuum script. |
| Previous Message | Thomas F.O'Connell | 2005-04-11 21:45:26 | Re: Trying to use initlocation |