[Pkg-postgresql-public] Bug#642133: 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

[Cédric Villemain]

Le lundi 25 juin 2012 18:20:42, Michael Stapelberg a écrit :
> 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?

You made a mistake. PostgreSQL used to have its parameter 'shared_buffers' (the 
one impacting shmmax) set to 24MB by default. It didn't changed.


-- 
Cédric Villemain +33 (0)6 20 30 22 52
http://2ndQuadrant.fr/
PostgreSQL: Support 24x7 - Développement, Expertise et Formation
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 490 bytes
Desc: This is a digitally signed message part.
URL: <http://lists.alioth.debian.org/pipermail/pkg-postgresql-public/attachments/20120625/97572a67/attachment-0001.pgp>