[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
cedric at 2ndquadrant.com
Mon Jun 25 16:42:46 UTC 2012
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>
More information about the Pkg-postgresql-public
mailing list