Re: Increasing Max Connections Mac OS 10.3 - Mailing list pgsql-general

From Tom Lane
Subject Re: Increasing Max Connections Mac OS 10.3
Date
Msg-id 17243.1076434122@sss.pgh.pa.us
Whole thread Raw
In response to Increasing Max Connections Mac OS 10.3  (Joe Lester <joe_lester@sweetwater.com>)
Responses Re: Increasing Max Connections Mac OS 10.3
List pgsql-general
Joe Lester <joe_lester@sweetwater.com> writes:
> Would this be kern.maxfiles?

Sounds like what you want.  There's probably no need to reduce
maxfilesperproc (and thereby constrain every process not only PG
backends).  You can set PG's max_files_per_process instead.

> Is it OK to set these before starting the server? Or should I set them
> in /etc/rc?

Damifino.  Try a manual sysctl -w and see if it takes ... if not, you
probably have to set it in /etc/rc.

            regards, tom lane

pgsql-general by date:

Previous
From: Brian Hirt
Date:
Subject: Re: Increasing Max Connections Mac OS 10.3
Next
From: Tom Lane
Date:
Subject: Re: Increasing Max Connections Mac OS 10.3