Created
March 18, 2014 04:45
-
-
Save evanthebouncy/9613715 to your computer and use it in GitHub Desktop.
postgresql shmall setting error
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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