• 周五. 8月 19th, 2022

5G编程聚合网

5G时代下一个聚合的编程学习网

热门标签

045.PGSQL-启动数据库报错Job for postgresql-13.service failed because the control process exited with error code. See "systemctl status postgresql-13.service" and "journalctl -xe" for details.

admin

11月 28, 2021

[[email protected] /var/lib/pgsql/13/data]#sudo systemctl restart postgresql-13
Job for postgresql-13.service failed because the control process exited with error code. See “systemctl status postgresql-13.service” and “journalctl -xe” for details.

 解决办法  journalctl -xe 查看日志

配置文件有书写错误

[[email protected] /var/lib/pgsql/13/data]#journalctl -xe

Aug 03 05:58:41 s101 sudo[57753]: root : TTY=pts/1 ; PWD=/var/lib/pgsql/13/data ; USER=root ; COMMAND=/bin/systemctl restart postgresql-13
Aug 03 05:58:41 s101 polkitd[606]: Registered Authentication Agent for unix-process:57754:131258586 (system bus name :1.1018 [/usr/bin/pkttyagent –notify-fd 5 –fallback], object path /org/freedesktop/PolicyKit1/AuthenticationAgent, locale en_US.UTF-8)
Aug 03 05:58:41 s101 polkitd[606]: Unregistered Authentication Agent for unix-process:57754:131258586 (system bus name :1.1018, object path /org/freedesktop/PolicyKit1/AuthenticationAgent, locale en_US.UTF-8) (disconnected from bus)
Aug 03 05:58:41 s101 systemd[1]: Starting PostgreSQL 13 database server…
— Subject: Unit postgresql-13.service has begun start-up
— Defined-By: systemd
— Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel

— Unit postgresql-13.service has begun starting up.
Aug 03 05:58:41 s101 systemd[1]: postgresql-13.service: main process exited, code=exited, status=1/FAILURE
Aug 03 05:58:41 s101 systemd[1]: Failed to start PostgreSQL 13 database server.
— Subject: Unit postgresql-13.service has failed
— Defined-By: systemd
— Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel

— Unit postgresql-13.service has failed.

— The result is failed.
Aug 03 05:58:41 s101 systemd[1]: Unit postgresql-13.service entered failed state.
Aug 03 05:58:41 s101 postmaster[57765]: 2021-08-02 21:58:41.154 GMT [57765] LOG: syntax error in file “/var/lib/pgsql/13/data/postgresql.conf” line 661, near token “,”
Aug 03 05:58:41 s101 postmaster[57765]: 2021-08-02 21:58:41.154 GMT [57765] FATAL: configuration file “/var/lib/pgsql/13/data/postgresql.conf” contains errors
Aug 03 05:58:41 s101 systemd[1]: postgresql-13.service failed.

发表回复

您的电子邮箱地址不会被公开。