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
