Postgres Pro
Downloads
Home   >   mailing lists

Re: [Mac OS X Mountain Lion] FATAL: could not create shared memory segment: Cannot allocate memory - Mailing list pgsql-general

From Yvon Thoraval
Subject Re: [Mac OS X Mountain Lion] FATAL: could not create shared memory segment: Cannot allocate memory
Date
Msg-id CAG6bkBwSxsNadPW4_xgvGiVbPV8AyM0m28OowXpUv0FJoQXRXg@mail.gmail.com
Whole thread Raw
In response to Re: [Mac OS X Mountain Lion] FATAL: could not create shared memory segment: Cannot allocate memory  (Scott Marlowe <scott.marlowe@gmail.com>)
Responses Re: [Mac OS X Mountain Lion] FATAL: could not create shared memory segment: Cannot allocate memory  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-general
Tree view


2012/10/7 Scott Marlowe <scott.marlowe@gmail.com>
http://www.postgresql.org/docs/9.2/static/kernel-resources.html


OK, fine thanks to both.

I've found a page dealing with that prob :

The points are to :

Easy to fix; run:

sudo sysctl -w kern.sysv.shmall=65536
sudo sysctl -w kern.sysv.shmmax=16777216
(The first one's the critical one for me, but second seems appropriate too.)

This changes the limits in the currently-running kernel. To make these values stick across reboots, add them to /etc/sysctl.conf, like this:

kern.sysv.shmall=65536
kern.sysv.shmmax=16777216
(Create this file if it doesn't already exist – it doesn't on fresh Leopard installs.)
--
Yvon


pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: [Mac OS X Mountain Lion] FATAL: could not create shared memory segment: Cannot allocate memory
Next
From: Vincent Veyron
Date:
Subject: Re: [PL/PGSQL] column name substitution in PG8.4