POSTGRESQL 无法启动解决方案

常用状态检查
sudo systemctl status –now odoo.service
systemctl status postgresql@14-main.service
sudo service php-fpm-74 status
如果是该错误:
FATAL: could not access private key file “/etc/ssl/private/ssl-cert-snakeoil>
Feb 17 23:53:16 mail.erp.casalandia.eu postgresql@14-main[3568]: 2023-02-17 23:53:16.896 UTC [3572] LOG: database system is shut down
则是上述目录中缺少ssl-cert-snakeoil.key文件
下载并上传最后附录的相应文件到上述目录。
然后运行以下代码:
# > It happened to me and it turned out that I removed erroneously the postgres user from "ssl-cert" group, set it back with
# 添加postgres到 ssl-cert组:
sudo gpasswd -a postgres ssl-cert

# Fixed ownership and mode 设置所属和权限代码:
sudo chown root:ssl-cert  /etc/ssl/private/ssl-cert-snakeoil.key
sudo chmod 740 /etc/ssl/private/ssl-cert-snakeoil.key

# now postgresql starts! (and install command doesn't fail anymore) 重启:
sudo /etc/init.d/postgresql start

#检查postgresql数据库状态:
其他常用代码:
启动数据库A: sudo pg_ctlcluster 14 main start
B: sudo systemctl start postgresql@14-main.service

给TA打赏
共{{data.count}}人
人已打赏
Windows

DLC Boot v3.6 全面且可移植的Windows故障排除程序

2020-9-24 0:26:08

odoo

如何在系统 Ubuntu 20.04 LTS中安装 Odoo 16

2024-3-27 14:13:48

各类网站开发

站长微信 710 342 444 或者扫一扫右侧二维码。
    0 条回复 A文章作者 M管理员
      暂无讨论,说说你的看法吧
    个人中心
    购物车
    优惠劵
    今日签到
    有新私信 私信列表
    搜索