Re: Installation woes via Macports on Mac OS X 10.7

Hi Scott,

On 2011-10-07, at 2:57 PM, Scott Ribe wrote:

> On Oct 7, 2011, at 2:24 PM, René Fournier wrote:
>
>> I've tried installation 8.4 and 9.0 on two different machines, and at the end can't start Postgresql. Here's the basic story:
>
> You can't change shmall & shmmax after boot. They must be set during startup. If you're on a recent version of OS X, you do this in /etc/sysctl.conf.

Well, I changed them at the shell and in sysctl, and restarted (on both machines).

>
> Also the /usr/bin/postgres that you seen running is not where macports puts it and not the one you tried to start a couple of lines earlier, so you have something already installed on your system that is running a postgres instance.

Yes, I forgot that machine was running Lion Server (with Postgresql already running).

However, on the other computer, running regular 10.7, the same problem persists, without a /usr/bin version.

Fri Oct 07 15:45:25 -- Frodo :: which psql
/opt/local/lib/postgresql84/bin/psql
Fri Oct 07 15:45:26 -- Frodo :: psql -U postgres
psql: could not connect to server: No such file or directory

Is the server running locally and accepting

connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
Fri Oct 07 15:45:29 -- Frodo :: ps -ax | grep "postgres"
26486 ?? 0:00.08 /opt/local/bin/daemondo --label=postgresql84-server --start-cmd /opt/local/etc/LaunchDaemons/org.macports.postgresql84-server/postgresql84-server.wrapper start ; --stop-cmd /opt/local/etc/LaunchDaemons/org.macports.postgresql84-server/postgresql84-server.wrapper stop ; --restart-cmd /opt/local/etc/LaunchDaemons/org.macports.postgresql84-server/postgresql84-server.wrapper restart ; --pid=none
30843 ?? 0:00.00 /opt/local/bin/daemondo --label=postgresql90-server --start-cmd /opt/local/etc/LaunchDaemons/org.macports.postgresql90-server/postgresql90-server.wrapper start ; --stop-cmd /opt/local/etc/LaunchDaemons/org.macports.postgresql90-server/postgresql90-server.wrapper stop ; --restart-cmd /opt/local/etc/LaunchDaemons/org.macports.postgresql90-server/postgresql90-server.wrapper restart ; --pid=none
30880 ttys002 0:00.00 grep postgres
Fri Oct 07 15:45:31 -- Frodo ::

So one thing that's odd, I have two version of postgresql apparently running (although I've removed 9.0 from Macports)… Not sure if this is the cause. Any other suggestions?

Best regards,
René Fournier