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: 357C48D9-0DE3-4D3C-BE03-BA45425EB057@gmx.de (view raw or flat)
Thread:
Lists: pgsql-admin
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


In response to

Responses

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-2014 The PostgreSQL Global Development Group