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
max_connections = 40
Does anybody see any problems with theese settings? The amount of
parallel connections should not be a big problem, because it is a
Thanks Tom and best Regards,
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
> 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
> TIP 4: Have you searched our list archives?
In response to
pgsql-admin by date
|Next:||From: Chris Hoover||Date: 2007-04-11 13:02:47|
|Subject: Bytea question|
|Previous:||From: Chuck Amadi||Date: 2007-04-11 08:36:57|
|Subject: Re: server startup script at boot|