Skip to content

Instantly share code, notes, and snippets.

@evanthebouncy
Created March 18, 2014 04:45
Show Gist options
  • Save evanthebouncy/9613715 to your computer and use it in GitHub Desktop.
Save evanthebouncy/9613715 to your computer and use it in GitHub Desktop.
postgresql shmall setting error
root@production:~# sudo /etc/init.d/postgresql start
* Starting PostgreSQL 9.1 database server * The PostgreSQL server failed to start. Please check the log output:
2014-03-18 00:39:51 EDT FATAL: could not create shared memory segment: Cannot allocate memory
2014-03-18 00:39:51 EDT DETAIL: Failed system call was shmget(key=5432001, size=430235648, 03600).
2014-03-18 00:39:51 EDT HINT: This error usually means that PostgreSQL's request for a shared memory segment exceeded available memory or swap space, or exceeded your kernel's SHMALL parameter. You can either reduce the request size or reconfigure the kernel with larger SHMALL. To reduce the request size (currently 430235648 bytes), reduce PostgreSQL's shared memory usage, perhaps by reducing shared_buffers or max_connections.
The PostgreSQL documentation contains more information about shared memory configuration.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment