☰

无法启动 PostgreSQL，错误看起来像是指向未找到数据库用户

tag-icon • tag-icon postgresql database
无法启动 PostgreSQL，错误看起来像是指向未找到数据库用户

请求有关尝试postgresql-9.6.2使用systemctl( systemd) 启动服务的帮助。

我正在安装一个监视工具，该工具安装 PostgreSQL 实例来支持该工具。它在安装过程中创建 postgres 用户。

我正在运行安装非root用户（根据文档，我可以选择以 root 或非 root 身份运行）

安装成功，检查状态postgresql-9.6.2然后尝试启动。

我收到此错误消息：

# systemctl status postgresql-9.6.2.service
● postgresql-9.6.2.service - SYSV: Starts and stops the PostgreSQL 9.6.2 database server
   Loaded: loaded (/etc/rc.d/init.d/postgresql-9.6.2; bad; vendor preset: disabled)
   Active: failed (Result: exit-code) since Wed 2022-11-09 01:05:41 GMT; 8min ago
     Docs: man:systemd-sysv-generator(8)
  Process: 9302 ExecStart=/etc/rc.d/init.d/postgresql-9.6.2 start (code=exited, status=1/FAILURE)

Nov 09 01:05:41 sxnda10053.delta.com systemd[1]: Starting SYSV: Starts and stops the PostgreSQL 9.6.2 database server...
Nov 09 01:05:41 10053.com postgresql-9.6.2[9302]: Starting PostgreSQL 9.6.2:
Nov 09 01:05:41 10053.com postgresql-9.6.2[9302]: su: user DB_SERVICE_USER does not exist
Nov 09 01:05:41 10053.com postgresql-9.6.2[9302]: PostgreSQL 9.6.2 did not start in a timely fashion, please see DB_INSTALL_DIR/pg_log/startup.log for details
Nov 09 01:05:41 10053.com systemd[1]: postgresql-9.6.2.service: control process exited, code=exited status=1
Nov 09 01:05:41 10053.com systemd[1]: Failed to start SYSV: Starts and stops the PostgreSQL 9.6.2 database server.
Nov 09 01:05:41 10053.com systemd[1]: Unit postgresql-9.6.2.service entered failed state.
Nov 09 01:05:41 10053.com systemd[1]: postgresql-9.6.2.service failed.
[root@10053 xdg]# systemctl start postgresql-9.6.2.service
Job for postgresql-9.6.2.service failed because the control process exited with error code. See "systemctl status postgresql-9.6.2.service" and "journalctl -xe" for details.

任何帮助将不胜感激。

相关内容