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

桃扇骨 2022-10-08 14:30 141阅读 0赞

版本

  1. # cat /etc/centos-release
  2. CentOS Linux release 7.6.1810 (Core)
  4. # yum list installed |grep -i postgresql
  5. postgresql10.x86_64                10.17-1PGDG.rhel7                   @pgdg10  
  6. postgresql10-contrib.x86_64        10.17-1PGDG.rhel7                   @pgdg10  
  7. postgresql10-devel.x86_64          10.17-1PGDG.rhel7                   @pgdg10  
  8. postgresql10-docs.x86_64           10.17-1PGDG.rhel7                   @pgdg10  
  9. postgresql10-libs.x86_64           10.17-1PGDG.rhel7                   @pgdg10  
  10. postgresql10-odbc.x86_64           13.00.0000-1PGDG.rhel7              @pgdg10  
  11. postgresql10-plperl.x86_64         10.17-1PGDG.rhel7                   @pgdg10  
  12. postgresql10-plpython.x86_64       10.17-1PGDG.rhel7                   @pgdg10  
  13. postgresql10-plpython3.x86_64      10.17-1PGDG.rhel7                   @pgdg10  
  14. postgresql10-pltcl.x86_64          10.17-1PGDG.rhel7                   @pgdg10  
  15. postgresql10-server.x86_64         10.17-1PGDG.rhel7                   @pgdg10  
  16. postgresql10-tcl.x86_64            2.7.5-1.rhel7                       @pgdg10  
  17. postgresql10-test.x86_64           10.17-1PGDG.rhel7                   @pgdg10

启动报错

  1. # systemctl start postgresql-10
  2. 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.
  4. # systemctl status postgresql-10.service
  5. ● postgresql-10.service - PostgreSQL 10 database server
  6.    Loaded: loaded (/usr/lib/systemd/system/postgresql-10.service; disabled; vendor preset: disabled)
  7.    Active: failed (Result: exit-code) since Tue 2021-06-22 09:45:06 CST; 20s ago
  8.      Docs: https://www.postgresql.org/docs/10/static/
  9.   Process: 14252 ExecStartPre=/usr/pgsql-10/bin/postgresql-10-check-db-dir ${PGDATA} (code=exited, status=1/FAILURE)
  11. Jun 22 09:45:06 xxoo systemd[1]: Starting PostgreSQL 10 database server...
  12. Jun 22 09:45:06 xxoo systemd[1]: postgresql-10.service: control process exited, code=exited status=1
  13. Jun 22 09:45:06 xxoo systemd[1]: Failed to start PostgreSQL 10 database server.
  14. Jun 22 09:45:06 xxoo systemd[1]: Unit postgresql-10.service entered failed state.
  15. Jun 22 09:45:06 xxoo systemd[1]: postgresql-10.service failed.
  17. # journalctl -xe
  18. Jun 22 09:43:15 xxoo systemd[1]: Unit postgresql-10.service entered failed state.
  19. Jun 22 09:43:15 xxoo systemd[1]: postgresql-10.service failed.
  20. 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
  21. Jun 22 09:44:29 xxoo systemd[1]: Starting Cleanup of Temporary Directories...
  22. -- Subject: Unit systemd-tmpfiles-clean.service has begun start-up
  23. -- Defined-By: systemd
  24. -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
  25. -- 
  26. -- Unit systemd-tmpfiles-clean.service has begun starting up.
  27. Jun 22 09:44:29 xxoo systemd[1]: Started Cleanup of Temporary Directories.
  28. -- Subject: Unit systemd-tmpfiles-clean.service has finished start-up
  29. -- Defined-By: systemd
  30. -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
  31. -- 
  32. -- Unit systemd-tmpfiles-clean.service has finished starting up.
  33. -- 
  34. -- The start-up result is done.
  35. 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
  36. Jun 22 09:45:06 xxoo systemd[1]: Starting PostgreSQL 10 database server...
  37. -- Subject: Unit postgresql-10.service has begun start-up
  38. -- Defined-By: systemd
  39. -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
  40. -- 
  41. -- Unit postgresql-10.service has begun starting up.
  42. Jun 22 09:45:06 xxoo postgresql-10-check-db-dir[14252]: "/var/lib/pgsql/10/data/" is missing or empty.
  43. 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.
  44. 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.
  45. Jun 22 09:45:06 xxoo systemd[1]: postgresql-10.service: control process exited, code=exited status=1
  46. Jun 22 09:45:06 xxoo systemd[1]: Failed to start PostgreSQL 10 database server.
  47. -- Subject: Unit postgresql-10.service has failed
  48. -- Defined-By: systemd
  49. -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
  50. -- 
  51. -- Unit postgresql-10.service has failed.
  52. -- 
  53. -- The result is failed.
  54. Jun 22 09:45:06 xxoo systemd[1]: Unit postgresql-10.service entered failed state.
  55. Jun 22 09:45:06 xxoo systemd[1]: postgresql-10.service failed.
  56. 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
  57. lines 1282-1320/1320 (END)

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

初始化

  1. # /usr/pgsql-10/bin/postgresql-10-setup initdb
  2. Initializing database ... OK
  4. # systemctl start postgresql-10
  5. # 
  6. # 
  7. # systemctl status postgresql-10
  8. ● postgresql-10.service - PostgreSQL 10 database server
  9.    Loaded: loaded (/usr/lib/systemd/system/postgresql-10.service; disabled; vendor preset: disabled)
  10.    Active: active (running) since Tue 2021-06-22 09:54:41 CST; 9s ago
  11.      Docs: https://www.postgresql.org/docs/10/static/
  12.   Process: 14447 ExecStartPre=/usr/pgsql-10/bin/postgresql-10-check-db-dir ${PGDATA} (code=exited, status=0/SUCCESS)
  13.  Main PID: 14453 (postmaster)
  14.    CGroup: /system.slice/postgresql-10.service
  15.            ├─14453 /usr/pgsql-10/bin/postmaster -D /var/lib/pgsql/10/data/
  16.            ├─14459 postgres: logger process   
  17.            ├─14463 postgres: checkpointer process   
  18.            ├─14464 postgres: writer process   
  19.            ├─14465 postgres: wal writer process   
  20.            ├─14466 postgres: autovacuum launcher process   
  21.            ├─14467 postgres: stats collector process   
  22.            └─14468 postgres: bgworker: logical replication launcher   
  24. Jun 22 09:54:41 xxoo systemd[1]: Starting PostgreSQL 10 database server...
  25. 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
  26. 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
  27. 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"
  28. 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"
  29. 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
  30. 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".
  31. Jun 22 09:54:41 xxoo systemd[1]: Started PostgreSQL 10 database server.

正常

发表评论

表情：
评论列表 （有 0 条评论，141人围观）

还没有评论，来说两句吧...

相关阅读