Re: [Mac OS X Mountain Lion] FATAL: could not create shared memory segment: Cannot allocate memory

2012/10/7 Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>

> 'd have posted more, but
>
> 1: I know just enough about MacOS to be dangerous and
> 2: MacOS is known for changing how shared memory works from one minor
> patch to another so..
> 3: Any page on making work will be dependent on the exact MacOS
> version you are running.
>

In fact i had already installed PostgreSQL on mac os x Lion, recently i
upgraded to mac os x mountain lion.
And also switching to a brew install of Postgres.
I don't why but it is more difficult, on Mountain Lion, than on Lion.
And also far more difficult than on (X)Ubuntu 12.04.

On Lion and Ubuntu i had only to change postgresql.conf and pg_hba.conf.

But here with ML (Mountain Lion) the server is running but not accepting
connection :
$ psgrep postgres
yt 47140 0,0 0,0 2444240 520 ?? Ss 1:20
0:00.00 postgres: wal writer process
yt 47139 0,0 0,0 2444240 564 ?? Ss 1:20
0:00.05 postgres: writer process
yt 47138 0,0 0,0 2444240 588 ?? Ss 1:20
0:00.00 postgres: checkpointer process
yt 47136 0,0 0,1 2444240 3696 s002 S+ 1:20
0:00.02 postgres -D /usr/local/var/postgres
yt 47142 0,0 0,0 2440520 400 ?? Ss 1:20
0:00.00 postgres: stats collector process
yt 47141 0,0 0,0 2444372 1528 ?? Ss 1:20
0:00.00 postgres: autovacuum launcher process

(my psgrep is an alias of 'ps aux | grep -v grep | grep')

$ psql -p 5433
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.5433"?

the socket is here :

/var/pgsql_socket $ ls -al
drwxr-xr-x 5 yt wheel 170 8 oct 01:27 .
drwxr-xr-x 26 root wheel 884 7 oct 14:00 ..
-rw-r--r-- 1 yt wheel 313 8 oct 01:08 .profile
srwxrwxrwx 1 yt wheel 0 8 oct 01:27 .s.PGSQL.5433
-rw------- 1 yt wheel 64 8 oct 01:27 .s.PGSQL.5433.lock

no socket at all in /tmp...

It's to late : 2 hours in the early morning here in Paris...

--
Yvon