[Lucid] Postgresql cannot start because of SHMMAX configuration
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
linux (Ubuntu) |
New
|
Undecided
|
Unassigned | ||
postgresql-8.4 (Ubuntu) |
New
|
Undecided
|
Unassigned |
Bug Description
$ sudo service postgresql-8.4 start
* Starting PostgreSQL 8.4 database server * The PostgreSQL server failed to start. Please check the log output:
2010-10-02 14:24:41 MSD FATAL: could not create shared memory segment: ???????????? ????????
2010-10-02 14:24:41 MSD DETAIL: Failed system call was shmget(key=5432001, size=36880384, 03600).
2010-10-02 14:24:41 MSD HINT: This error usually means that PostgreSQL's request for a shared memory segment exceeded your kernel's SHMMAX parameter. You can either reduce the request size or reconfigure the kernel with larger SHMMAX. To reduce the request size (currently 36880384 bytes), reduce PostgreSQL's shared_buffers parameter (currently 4096) and/or its max_connections parameter (currently 103).
If the request size is already small, it's possible that it is less than your kernel's SHMMIN parameter, in which case raising the request size or reconfiguring SHMMIN is called for.
The PostgreSQL documentation contains more information about shared memory configuration.
Used to work with previous kernel.
ProblemType: Bug
DistroRelease: Ubuntu 10.04
Package: linux-image-
Regression: Yes
Reproducible: Yes
ProcVersionSign
Uname: Linux 2.6.32-25-generic i686
AlsaVersion: Advanced Linux Sound Architecture Driver Version 1.0.21.
Architecture: i386
ArecordDevices:
**** List of CAPTURE Hardware Devices ****
card 0: Intel [HDA Intel], device 0: ALC268 Analog [ALC268 Analog]
Subdevices: 1/1
Subdevice #0: subdevice #0
AudioDevicesInUse:
USER PID ACCESS COMMAND
/dev/snd/
CRDA: Error: [Errno 2] Нет такого файла или каталога
Card0.Amixer.info:
Card hw:0 'Intel'/'HDA Intel at 0x94400000 irq 22'
Mixer name : 'Realtek ALC268'
Components : 'HDA:10ec0268,
Controls : 18
Simple ctrls : 10
Date: Sat Oct 2 14:25:51 2010
HibernationDevice: RESUME=
InstallationMedia: Ubuntu 10.04.1 LTS "Lucid Lynx" - Release i386 (20100816.1)
IwConfig:
lo no wireless extensions.
eth0 no wireless extensions.
vboxnet0 no wireless extensions.
MachineType: TOSHIBA Satellite A300
ProcCmdLine: BOOT_IMAGE=
ProcEnviron:
LANG=ru_RU.utf8
SHELL=/bin/bash
RelatedPackageV
RfKill:
SourcePackage: linux
WifiSyslog:
dmi.bios.date: 06/27/2008
dmi.bios.vendor: INSYDE
dmi.bios.version: 1.50
dmi.board.
dmi.board.name: Base Board Product Name
dmi.board.vendor: Intel Corp.
dmi.board.version: Base Board Version
dmi.chassis.
dmi.chassis.type: 1
dmi.chassis.vendor: Chassis Manufacturer
dmi.chassis.
dmi.modalias: dmi:bvnINSYDE:
dmi.product.name: Satellite A300
dmi.product.
dmi.sys.vendor: TOSHIBA
Btw, Postgresql wrongly reports it's parameters, real are:
shared_buffers = 32MB
max_connections = 100
after changing:
shared_buffers = 4MB
PostgreSql finally started.