Skip site navigation (1) Skip section navigation (2)

Re: Problems with precompiled pgsql on mac

From: Peter Elmers <p(dot)elmers(at)gmx(dot)de>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Problems with precompiled pgsql on mac
Date: 2007-04-11 09:12:07
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin

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

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,


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?

In response to


pgsql-admin by date

Next:From: Chris HooverDate: 2007-04-11 13:02:47
Subject: Bytea question
Previous:From: Chuck AmadiDate: 2007-04-11 08:36:57
Subject: Re: server startup script at boot

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group