postgresql 运行报错 FATAL: could not map anonymous shared memory

修改内核参数
vi /etc/sysctl.conf

# vi /etc/sysctl.conf
vm.overcommit_memory = 2
vm.overcommit_ratio = 90
vm.swappiness = 1

# sysctl -p

sysctl -p 需要耐心等待一段时间
查看内存

# ls -l /proc/self/oom_*
-rw-r--r-- 1 root root 0 Dec 26 14:18 /proc/self/oom_adj
-r--r--r-- 1 root root 0 Dec 26 14:18 /proc/self/oom_score
-rw-r--r-- 1 root root 0 Dec 26 14:18 /proc/self/oom_score_adj

修改rc.local

# vi /etc/rc.local 
echo -1000 > /proc/self/oom_score_adj 

# vi /etc/profile
export PG_OOM_ADJUST_FILE=/proc/self/oom_score_adj
export PG_OOM_ADJUST_VALUE=0