Linux：postgresql-14启动报错

最新推荐文章于 2024-08-19 18:31:51 发布

weixin_72585038

最新推荐文章于 2024-08-19 18:31:51 发布

阅读量1.9k

点赞数

文章标签： linux postgresql 运维

本文链接：https://blog.csdn.net/weixin_72585038/article/details/134533065

版权

一、问题

启动pg14时报错，提示Job for postgresql-14.service failed because the control process exited with error code.

journalctl -xe 查看启动过程时发现，具体报错为could not load server certificate file “server.crt”：No such file or directory

[root@scyf-db data]# systemctl status postgresql-14
● postgresql-14.service - PostgreSQL 14 database server
   Loaded: loaded (/usr/lib/systemd/system/postgresql-14.service; enabled; vendor preset: disabled)
   Active: failed (Result: exit-code) since Tue 2023-11-21 14:18:41 CST; 18min ago
     Docs: https://www.postgresql.org/docs/14/static/
  Process: 51051 ExecStart=/usr/pgsql-14/bin/postmaster -D ${PGDATA} (code=exited, status=1/FAILURE)
  Process: 51045 ExecStartPre=/usr/pgsql-14/bin/postgresql-14-check-db-dir ${PGDATA} (code=exited, status=0/SUCCESS)
 Main PID: 51051 (code=exited, status=1/FAILURE)

Nov 21 14:18:41 scyf-db systemd[1]: Starting PostgreSQL 14 database server...
Nov 21 14:18:41 scyf-db postmaster[51051]: 2023-11-21 14:18:41.446 CST [51051] FATAL:  could not load server certificate file "serv...rectory
Nov 21 14:18:41 scyf-db systemd[1]: postgresql-14.service: main process exited, code=exited, status=1/FAILURE
Nov 21 14:18:41 scyf-db systemd[1]: Failed to start PostgreSQL 14 database server.
Nov 21 14:18:41 scyf-db systemd[1]: Unit postgresql-14.service entered failed state.
Nov 21 14:18:41 scyf-db systemd[1]: postgresql-14.service failed.
Hint: Some lines were ellipsized, use -l to show in full.
[root@scyf-db data]# systemctl start postgresql-14
Job for postgresql-14.service failed because the control process exited with error code. See "systemctl status postgresql-14.service" and "journalctl -xe" for details.
[root@scyf-db data]# journalctl -xe >>123.sh
[root@scyf-db data]# vim 123.sh

内容
--------------------------
-- Unit postgresql-14.service has begun starting up.
Nov 21 14:36:52 scyf-db postmaster[52011]: 2023-11-21 14:36:52.300 CST [52011] FATAL:  could not load server certificate file "server.crt": No such file or directory
Nov 21 14:36:52 scyf-db polkitd[870]: Unregistered Authentication Agent for unix-process:51999:4175129641 (system bus name :1.25052, object path /org/freedesktop/PolicyKit1/AuthenticationAgent, locale en_US.UTF-8) (disconnected from bus)
Nov 21 14:36:52 scyf-db systemd[1]: postgresql-14.service: main process exited, code=exited, status=1/FAILURE
Nov 21 14:36:52 scyf-db postmaster[52011]: 2023-11-21 14:36:52.300 CST [52011] LOG:  database system is shut down
Nov 21 14:36:52 scyf-db systemd[1]: Failed to start PostgreSQL 14 database server.
-- Subject: Unit postgresql-14.service has failed
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
-- 
-- Unit postgresql-14.service has failed.
-- 
-- The result is failed.
Nov 21 14:36:52 scyf-db systemd[1]: Unit postgresql-14.service entered failed state.
Nov 21 14:36:52 scyf-db systemd[1]: postgresql-14.service failed.

二、解决办法

修改配置文件postgresql.conf文件中的ssl，使其为off

[root@scyf-db data]# vim postgresql.conf 
[root@scyf-db data]# systemctl start postgresql-14
[root@scyf-db data]# systemctl status postgresql-14
● postgresql-14.service - PostgreSQL 14 database server
   Loaded: loaded (/usr/lib/systemd/system/postgresql-14.service; enabled; vendor preset: disabled)
   Active: active (running) since Tue 2023-11-21 14:42:00 CST; 15s ago
     Docs: https://www.postgresql.org/docs/14/static/
  Process: 52271 ExecStartPre=/usr/pgsql-14/bin/postgresql-14-check-db-dir ${PGDATA} (code=exited, status=0/SUCCESS)
 Main PID: 52279 (postmaster)
   CGroup: /system.slice/postgresql-14.service
           ├─52279 /usr/pgsql-14/bin/postmaster -D /u01/apps/pgsql14/data/
           ├─52280 postgres: logger 
           ├─52283 postgres: checkpointer