Re: PGSQL Bug

On Thu, Jul 18, 2013 at 10:52 AM, Michael Kunzmann <mail(at)michaelkunzmann(dot)com
> wrote:

> Am 18.07.2013 17:33, schrieb bricklen:
>
>
> On Wed, Jul 17, 2013 at 10:46 PM, Michael Kunzmann <
> mail(at)michaelkunzmann(dot)com> wrote:
>
>>
>> I've noticed the following issue when autostarting PostgreSQL under
>> Ubuntu 12.04 64bit by bootup. I'm using PostgreSQL 9.1.
>>
>> 2013-07-18 06:44:12 CEST FATAL: could not create shared memory segment:
>>
>
> How much RAM do you have, and what does the output of the following
> command:
> sysctl -ar 'kernel.shm'
>
> Hello, I have 8GB of RAM.
>
> The values are:
> kernel.shm_rmid_forced = 0
> kernel.shmall = 2097152
> kernel.shmmax = 268435456
> kernel.shmmni = 4096
>
>
Set your kernel.shmall and kernel.shmmax higher in /etc/sysctl.conf. Eg.
kernel.shmall = 6442450944
kernel.shmmax = 6442450944

-- Reload after changing it
sudo sysctl -p

More details can be found here:
http://www.postgresql.org/docs/current/static/kernel-resources.html