Re: Problems with precompiled pgsql on mac

Hi!

Yes, that is indeed the problem.
I tried the recommended settings for sysctl.conf. Now ard and
postgresql are working well together.

Now i am ongoing to optimize the settings. Without changing the
sysctl.conf or rc, i am able to get postgres running with the
following settings:

max_connections = 40
shared_buffers=640kB

Does anybody see any problems with theese settings? The amount of
parallel connections should not be a big problem, because it is a
dedicated database.

Thanks Tom and best Regards,

Peter

Am 10.04.2007 um 16:30 schrieb Tom Lane:

> Peter Elmers <p(dot)elmers(at)gmx(dot)de> writes:
>> The problem is not solved, but we reduced it: it occures only if
>> apple remote desktop is running. So switching off ARD results in a
>> running postgresql system.
>> But this can only be a workaround. Does anybody know why the two
>> programs do not work together? Google says that ARD uses postgres,
>> too. But we are using another port and another user...
>
> Yeah, I believe ARD does have an embedded postgres instance. You
> might
> be running into Apple's ridiculously low system-wide SHMMAX setting;
> it's only big enough to let one postgres run at a time, unless you
> hobble performance by reducing shared_buffers etc well below default.
> See our manual for how to increase SHMMAX on OS X --- it's trickier
> than it ought to be :-(
>
> regards, tom lane
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org