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
