Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





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.

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



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux