Error when update postgresql to 9.6
Gitlab omnipackage 8.16.6 runned in OpenVZ virtual container without hardware limit
uname -a:
2.6.32-042stab112.15 #1 SMP Tue Oct 20 17:22:56 MSK 2015 x86_64 x86_64 x86_64 GNU/Linux
disk:
/dev/md2 4.0T 2.8T 1.1T 73% /
memory:
Cpu(s): 1.8%us, 12.2%sy, 0.0%ni, 85.4%id, 0.6%wa, 0.0%hi, 0.0%si, 0.0%st Mem: 65632744k total, 64010680k used, 1622064k free, 612340k buffers Swap: 16760828k total, 3737040k used, 13023788k free, 45921240k cached
i run gitlab-ctl pg_upgrade and get this:
PostgreSQL 9.6 is not started
in current postgres log:
2017-02-20_19:51:00.34918 received TERM from runit, sending INT instead to force quit connections 2017-02-20_19:51:00.61344 FATAL: could not open shared memory segment "/PostgreSQL.1598966119": Permission denied 2017-02-20_19:51:00.64447 LOG: database system is shut down 2017-02-20_19:51:02.04497 received TERM from runit, sending INT instead to force quit connections 2017-02-20_19:51:02.09476 FATAL: could not open shared memory segment "/PostgreSQL.1798780556": Permission denied 2017-02-20_19:51:02.12745 LOG: database system is shut down 2017-02-20_19:51:03.60728 FATAL: could not open shared memory segment "/PostgreSQL.1272778186": Permission denied 2017-02-20_19:51:03.63929 LOG: database system is shut down 2017-02-20_19:51:05.29379 FATAL: could not open shared memory segment "/PostgreSQL.1002275213": Permission denied 2017-02-20_19:51:05.32856 LOG: database system is shut down
Google say: http://www.sysadminguide.net/postgres-9-4-failed-to-start-in-container-how-to-fix/
i administrate 8 gitlab setups on openVZ containers, and this problem occurred only on the server with old version 112.15 of OpenVZ kernel.
Оn other openVZ host kernel version is 116.2 and newer
i plan to upgrade openVZ kernel on problem host, but
can you add in gitlab.rb config optional settings and activate this setting only if postgresql version is 9.6 ?
postgresql['dynamic_shared_memory_type'] = "none"