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 <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings