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

[Ralf Schuchardt <rasc@xxxxxx>]

Am 08.10.2012 um 02:08 schrieb Yvon Thoraval <yvon.thoraval@xxxxxxxxx>:

2012/10/7 Scott Marlowe <scott.marlowe@xxxxxxxxx>

'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.

Using sysctl to set the shm* values has consistently worked for us in the last years ...

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...

Mountain Lion comes with it's own version of PostgreSQL. The included psql command probably searches for unix sockets in a different place than your self compiled version. Is your path correctly set?

Ralf

<<attachment: smime.p7s>>