systemctl start postgresql-10 第一次启动报错

最新推荐文章于 2024-08-04 23:27:22 发布
最新推荐文章于 2024-08-04 23:27:22 发布
阅读量2.7k 收藏 1
点赞数
CC 4.0 BY-SA版权
分类专栏： # postgresql basic 文章标签： pg postgresql initdb
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/ctypyb2002/article/details/118100612
该博客记录了在CentOS7系统上遇到PostgreSQL10服务启动失败的情况，通过检查系统日志和使用`postgresql-10-setup initdb`初始化数据库集群，最终成功启动了PostgreSQL10服务。

摘要生成于 C知道 ，由 DeepSeek-R1 满血版支持， 前往体验 >

版本

# cat /etc/centos-release
CentOS Linux release 7.6.1810 (Core)

# yum list installed |grep -i postgresql
postgresql10.x86_64                10.17-1PGDG.rhel7                   @pgdg10  
postgresql10-contrib.x86_64        10.17-1PGDG.rhel7                   @pgdg10  
postgresql10-devel.x86_64          10.17-1PGDG.rhel7                   @pgdg10  
postgresql10-docs.x86_64           10.17-1PGDG.rhel7                   @pgdg10  
postgresql10-libs.x86_64           10.17-1PGDG.rhel7                   @pgdg10  
postgresql10-odbc.x86_64           13.00.0000-1PGDG.rhel7              @pgdg10  
postgresql10-plperl.x86_64         10.17-1PGDG.rhel7                   @pgdg10  
postgresql10-plpython.x86_64       10.17-1PGDG.rhel7                   @pgdg10  
postgresql10-plpython3.x86_64      10.17-1PGDG.rhel7                   @pgdg10  
postgresql10-pltcl.x86_64          10.17-1PGDG.rhel7                   @pgdg10  
postgresql10-server.x86_64         10.17-1PGDG.rhel7                   @pgdg10  
postgresql10-tcl.x86_64            2.7.5-1.rhel7                       @pgdg10  
postgresql10-test.x86_64           10.17-1PGDG.rhel7                   @pgdg10

启动报错

# systemctl start postgresql-10
Job for postgresql-10.service failed because the control process exited with error code. See "systemctl status postgresql-10.service" and "journalctl -xe" for details.


# systemctl status postgresql-10.service
● postgresql-10.service - PostgreSQL 10 database server
   Loaded: loaded (/usr/lib/systemd/system/postgresql-10.service; disabled; vendor preset: disabled)
   Active: failed (Result: exit-code) since Tue 2021-06-22 09:45:06 CST; 20s ago
     Docs: https://www.postgresql.org/docs/10/static/
  Process: 14252 ExecStartPre=/usr/pgsql-10/bin/postgresql-10-check-db-dir ${PGDATA} (code=exited, status=1/FAILURE)

Jun 22 09:45:06 xxoo systemd[1]: Starting PostgreSQL 10 database server...
Jun 22 09:45:06 xxoo systemd[1]: postgresql-10.service: control process exited, code=exited status=1
Jun 22 09:45:06 xxoo systemd[1]: Failed to start PostgreSQL 10 database server.
Jun 22 09:45:06 xxoo systemd[1]: Unit postgresql-10.service entered failed state.
Jun 22 09:45:06 xxoo systemd[1]: postgresql-10.service failed.


# journalctl -xe
Jun 22 09:43:15 xxoo systemd[1]: Unit postgresql-10.service entered failed state.
Jun 22 09:43:15 xxoo systemd[1]: postgresql-10.service failed.
Jun 22 09:43:15 xxoo polkitd[2741]: Unregistered Authentication Agent for unix-process:14204:82813 (system bus name :1.77, object path /org/freedesktop/PolicyKit1/AuthenticationAgent, local
Jun 22 09:44:29 xxoo systemd[1]: Starting Cleanup of Temporary Directories...
-- Subject: Unit systemd-tmpfiles-clean.service has begun start-up
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
-- 
-- Unit systemd-tmpfiles-clean.service has begun starting up.
Jun 22 09:44:29 xxoo systemd[1]: Started Cleanup of Temporary Directories.
-- Subject: Unit systemd-tmpfiles-clean.service has finished start-up
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
-- 
-- Unit systemd-tmpfiles-clean.service has finished starting up.
-- 
-- The start-up result is done.
Jun 22 09:45:06 xxoo polkitd[2741]: Registered Authentication Agent for unix-process:14245:93949 (system bus name :1.78 [/usr/bin/pkttyagent --notify-fd 5 --fallback], object path /org/free
Jun 22 09:45:06 xxoo systemd[1]: Starting PostgreSQL 10 database server...
-- Subject: Unit postgresql-10.service has begun start-up
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
-- 
-- Unit postgresql-10.service has begun starting up.
Jun 22 09:45:06 xxoo postgresql-10-check-db-dir[14252]: "/var/lib/pgsql/10/data/" is missing or empty.
Jun 22 09:45:06 xxoo postgresql-10-check-db-dir[14252]: Use "/usr/pgsql-10/bin/postgresql-10-setup initdb" to initialize the database cluster.
Jun 22 09:45:06 xxoo postgresql-10-check-db-dir[14252]: See /usr/share/doc/postgresql10-10.17/README.rpm-dist for more information.
Jun 22 09:45:06 xxoo systemd[1]: postgresql-10.service: control process exited, code=exited status=1
Jun 22 09:45:06 xxoo systemd[1]: Failed to start PostgreSQL 10 database server.
-- Subject: Unit postgresql-10.service has failed
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
-- 
-- Unit postgresql-10.service has failed.
-- 
-- The result is failed.
Jun 22 09:45:06 xxoo systemd[1]: Unit postgresql-10.service entered failed state.
Jun 22 09:45:06 xxoo systemd[1]: postgresql-10.service failed.
Jun 22 09:45:06 xxoo polkitd[2741]: Unregistered Authentication Agent for unix-process:14245:93949 (system bus name :1.78, object path /org/freedesktop/PolicyKit1/AuthenticationAgent, local
lines 1282-1320/1320 (END)

“/var/lib/pgsql/10/data/” is missing or empty.
好吧，没有初始化

初始化

# /usr/pgsql-10/bin/postgresql-10-setup initdb
Initializing database ... OK


# systemctl start postgresql-10
# 
# 
# systemctl status postgresql-10
● postgresql-10.service - PostgreSQL 10 database server
   Loaded: loaded (/usr/lib/systemd/system/postgresql-10.service; disabled; vendor preset: disabled)
   Active: active (running) since Tue 2021-06-22 09:54:41 CST; 9s ago
     Docs: https://www.postgresql.org/docs/10/static/
  Process: 14447 ExecStartPre=/usr/pgsql-10/bin/postgresql-10-check-db-dir ${PGDATA} (code=exited, status=0/SUCCESS)
 Main PID: 14453 (postmaster)
   CGroup: /system.slice/postgresql-10.service
           ├─14453 /usr/pgsql-10/bin/postmaster -D /var/lib/pgsql/10/data/
           ├─14459 postgres: logger process   
           ├─14463 postgres: checkpointer process   
           ├─14464 postgres: writer process   
           ├─14465 postgres: wal writer process   
           ├─14466 postgres: autovacuum launcher process   
           ├─14467 postgres: stats collector process   
           └─14468 postgres: bgworker: logical replication launcher   

Jun 22 09:54:41 xxoo systemd[1]: Starting PostgreSQL 10 database server...
Jun 22 09:54:41 xxoo postmaster[14453]: 2021-06-22 09:54:41.579 CST [14453] LOG:  listening on IPv4 address "127.0.0.1", port 5432
Jun 22 09:54:41 xxoo postmaster[14453]: 2021-06-22 09:54:41.581 CST [14453] LOG:  could not create IPv6 socket for address "::1": Address family not supported by protocol
Jun 22 09:54:41 xxoo postmaster[14453]: 2021-06-22 09:54:41.585 CST [14453] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
Jun 22 09:54:41 xxoo postmaster[14453]: 2021-06-22 09:54:41.592 CST [14453] LOG:  listening on Unix socket "/tmp/.s.PGSQL.5432"
Jun 22 09:54:41 xxoo postmaster[14453]: 2021-06-22 09:54:41.608 CST [14453] LOG:  redirecting log output to logging collector process
Jun 22 09:54:41 xxoo postmaster[14453]: 2021-06-22 09:54:41.608 CST [14453] HINT:  Future log output will appear in directory "log".
Jun 22 09:54:41 xxoo systemd[1]: Started PostgreSQL 10 database server.

正常

centos7.9下给Postgresql11安装wal2json插件_并获取CDC增量同步数据_同时通过分页解决变更记录数据过大_获取效率低的问题---PostgreSQL工作笔记003
添柴程序猿的专栏
06-06 449
安装postgresql11以后,然后我们来看如何给postgresql11,来安装wal2json插件,这个插件可以把postgresql产生的cdc增量数据日志,转换城json数据供我们使用比较方便.注意: 这里我们使用postgresql的版本是11,其实安装了一个最新的15版本的,但是15版本的不能用Navicat进行连接操作,会报错,使用起来麻烦,所以又找了一台机器安装了一个11版本的.直接在创建的表中,进行新增,删除,修改表记录的话那么,就会产生变更记录。
PostgreSQL 16.3+pg_rman 1.3.16的测试
sqlora的专栏
07-05 524
测试要求：准备虚机：操作系统centos 7.9 + 数据库postgresql v16.3实现目标：创建一个test数据库，建个建个t表，并随意插入几条记录，再建个t1表，最后删掉t表，记录删掉前的时间，恢复到删掉前的状态。利用pg_rman做备份和恢复操作：对库做备份后，可以删掉test表，利用备份做恢复。
Failed to start PostgreSQL 11 database server的解决办法
叉叉敌的博客
02-17 1万+