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.

摘要:
[ root@s101/var/lib/pgsql/13/data]#sudsysystemctlrestartpostgresql-13Jobforpostgresql.13.service失败,原因是使用了控制进程错误代码。请参阅“systemctlstatuspstgresql-13.service”和“journalctl-

[root@s101 /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.

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.第1张

 解决办法  journalctl -xe 查看日志

配置文件有书写错误

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.第2张

[root@s101 /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.

免责声明:文章转载自《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.》仅用于学习参考。如对内容有疑问,请及时联系本站处理。

上篇单色三角形(hdu-5072RTMP & HLS下篇

宿迁高防,2C2G15M,22元/月;香港BGP,2C5G5M,25元/月 雨云优惠码:MjYwNzM=

相关文章

如何在Ubuntu 18.04上安装和使用PostgreSQL

  如何在Ubuntu 18.04上安装和使用PostgreSQL 关系数据库管理系统是许多网站和应用程序的关键组成部分。它们提供了一种结构化的方式来存储,组织和访问信息。 PostgreSQL或Postgres是一个关系数据库管理系统,提供SQL查询语言的实现。它是许多小型和大型项目的流行选择,并且具有符合标准并具有许多高级功能(如可靠事务和并发读取锁...

CentOS 7 安装、配置、使用 PostgreSQL 9.5及PostGIS2.2

学习CentOS下安装使用PostgreSQL 【安装过程】 1.添加RPM    yum install https://download.postgresql.org/pub/repos/yum/9.5/redhat/rhel-7-x86_64/pgdg-centos95-9.5-2.noarch.rpm2.安装PostgreSQL 9.5     y...

自建 Gitlab (邮箱配置、拆分 PostgreSQL、Redis) + 随想

前言 最近折腾了一番自建 gitlab,在此做个记录,供君参考。整个构建过程基于 Docker Swarm(近期有计划将微服务移植到 Kubernetes,但还没倒腾顺手,暂时先沿用旧的方案),主题配图与主题无关,请忽略...... 1. 快速启用 配置的一般原则是先可用再优化,简单启动 gitlab 只需要一条命令: sudo docker run --...

centos7下安装postgresql13

PostgreSQL13 install 本机环境 [root@sonarqube02 ~]# cat /etc/redhat-release CentOS Linux release 7.8.2003(Core) [root@sonarqube02 ~]# cat /proc/version Linux version 3.10.0-1127.19....

greenplum(postgresql) 数据字典

greenplum是基于postgresql开发的分布式数据库,里面大部分的数据字典是一样的。我们在维护gp的时候对gp的数据字典比较熟悉,特此分享给大家。在这里不会详细介绍每个字典的内容,只会介绍常见的应用以及一些已经封装好了的函数。具体的介绍大家可以去看postgresql的中文文档(附件),里面有详细的解释。 1.postgresql中,所有数据库的...

PostgreSQL和Oracle的sql差异

PostgreSQL和Oracle的sql差异   1.rownum (1)Oracle分页查询使用rownum,PostgreSQL使用limit offset ORACLE POSTGRESQL select * from (select rownum r,e.* from emp e where rownum <=5) t where...