PostgreSQL在狮子OS X上失败并出现以下错误 [英] postgresql failing with below error on lion os x

问题描述

 Failed system call was shmget(key=5432001, size=16498688, 03600).
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 16498688 bytes), reduce PostgreSQL's shared_buffers parameter (currently 1536) and/or its max_connections parameter (currently 104).
    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.

推荐答案

这与Shared Memory参数（shared_buffers）有关）在PostgreSQL配置文件中。 Linux还具有适当的设置来限制应用程序可以请求的内存量。这些设置存储在三个文件中：-

This has to do with the Shared Memory parameter (shared_buffers) in the PostgreSQL configuration file. Linux also has settings in place to limit the amount of memory an application can request. These settings are stored in three files :-

/ proc / sys / kernel / shmall

/proc/sys/kernel/shmall

/ proc / sys / kernel / shmmax

/proc/sys/kernel/shmmax

/ proc / sys / kernel / shmmni

/proc/sys/kernel/shmmni

这些文件中的一个或多个需要进行修改或使用 sysctl可执行文件。请您的系统管理员执行此操作。错误消息会告诉您这些值应该是什么。 PostgreSQL然后应该能够正常启动。

One or more of these files need to be amended or by using the "sysctl" executable. Ask your system administrator to do this. The error message tells you what the values should be. PostgreSQL should then be able to startup properly.

如果无法更改值，请将shared_buffers参数减小到低于阈值的位置

If you are unable to change the values, reduce the shared_buffers parameter to a point where it is below the threshold

这篇关于PostgreSQL在狮子OS X上失败并出现以下错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！