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/8 Ralf Schuchardt <rasc@xxxxxx>


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

probably i missed that point because my last install of postgres was on ubuntu...
 

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?

right, the client only.
my path is correctly set, resarting the computer helps.
i'm now able to connect using tcp/ip :
$ psql -h localhost -p 5433 -U yt -d yt_tests
psql (9.2.1)
Type "help" for help.

yt_tests=# CREATE EXTENSION unaccent;
CREATE EXTENSION
yt_tests=# select unaccent('Hôtel');
 unaccent 
----------
 Hotel
(1 row) 

may be something was wrong with postmaster.pid and the socket ?
unclear to me but it "seems" to work right now.

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