[Pkg-postgresql-public] Bug#642133: [postgresql-9.1] After upgrading from 9.0 to 9.1 postgres fails to start: FATAL: could not create shared memory segment: Invalid argument

[Michael Stapelberg]

Hi,

Quoting Michael Stapelberg (2012-06-25 18:12:34)
> Interestingly, shmmax was set to 5 MB:
> 
> $ sysctl -a | grep shm
> kernel.shmmax = 5922496
> kernel.shmall = 2097152
> kernel.shmmni = 4096

Even more interestingly, when I wanted to make the change permanent in
/etc/sysctl.conf, I read:

$ tail -3 /etc/sysctl.conf
# necessary for postgresql 9.1 to even start
kernel.shmmax= 5922496

Implying that I already ran into this problem, but at that time, 5922496
was the correct amount of memory to get it started. Is this plausible or
did I make a mistake when saving that value? Did the SHM requirements of
postgresql increase recently within 9.1?

Best regards,
Michael