| 网站首页 | 业界新闻 | 小组 | 威客 | 人才 | 下载频道 | 博客 | 代码贴 | 在线编程 | 编程论坛
欢迎加入我们,一同切磋技术
用户名:   
 
密 码:  
共有 1339 人关注过本帖
标题:pgsql10重启后,一直启动不了
只看楼主 加入收藏
jiaxunwin
Rank: 1
等 级:新手上路
帖 子:1
专家分:0
注 册:2021-9-28
收藏
 问题点数:0 回复次数:0 
pgsql10重启后,一直启动不了
postgresql-10.service - PostgreSQL 10 database server
   Loaded: loaded (/usr/lib/systemd/system/postgresql-10.service; enabled; vendor preset: disabled)
   Active: failed (Result: exit-code) since Tue 2021-09-28 10:08:50 CST; 11s ago
     Docs: https://www.
  Process: 12890 ExecStart=/usr/pgsql-10/bin/postmaster -D ${PGDATA} (code=exited, status=1/FAILURE)
  Process: 12885 ExecStartPre=/usr/pgsql-10/bin/postgresql-10-check-db-dir ${PGDATA} (code=exited, status=0/SUCCESS)
 Main PID: 12890 (code=exited, status=1/FAILURE)

Sep 28 10:08:50 instance-v8llngb0 postmaster[12890]: 2021-09-28 10:08:50.270 CST [12890] LOG:  listening on IPv4 address "0.0.0.0", port 5432Sep 28 10:08:50 instance-v8llngb0 postmaster[12890]: 2021-09-28 10:08:50.270 CST [12890] LOG:  listening on IPv6 address "::", port 5432
Sep 28 10:08:50 instance-v8llngb0 postmaster[12890]: 2021-09-28 10:08:50.272 CST [12890] LOG:  listening on Unix socket "/var/run/po....5432"Sep 28 10:08:50 instance-v8llngb0 postmaster[12890]: 2021-09-28 10:08:50.276 CST [12890] LOG:  listening on Unix socket "/tmp/.s.PGSQL.5432"
Sep 28 10:08:50 instance-v8llngb0 postmaster[12890]: 2021-09-28 10:08:50.288 CST [12890] LOG:  redirecting log output to logging col...rocessSep 28 10:08:50 instance-v8llngb0 postmaster[12890]: 2021-09-28 10:08:50.288 CST [12890] HINT:  Future log output will appear in dir..."log".Sep 28 10:08:50 instance-v8llngb0 systemd[1]: postgresql-10.service: main process exited, code=exited, status=1/FAILURE
Sep 28 10:08:50 instance-v8llngb0 systemd[1]: Failed to start PostgreSQL 10 database server.
Sep 28 10:08:50 instance-v8llngb0 systemd[1]: Unit postgresql-10.service entered failed state.
Sep 28 10:08:50 instance-v8llngb0 systemd[1]: postgresql-10.service failed.
Hint: Some lines were ellipsized, use -l to show in full.

查明原因:
2021-09-28 13:51:30.457 CST [29540] LOG:  could not stat file "pg_tblspc/16871": No such file or directory
2021-09-28 13:51:30.457 CST [29540] LOG:  could not stat file "pg_tblspc/18927": No such file or directory
2021-09-28 13:51:30.457 CST [29540] LOG:  could not stat file "pg_tblspc/16870": No such file or directory
2021-09-28 13:51:30.457 CST [29540] LOG:  could not open tablespace directory "pg_tblspc/16871/PG_10_201707211": No such file or directory
2021-09-28 13:51:30.457 CST [29540] LOG:  could not open tablespace directory "pg_tblspc/18927/PG_10_201707211": No such file or directory
2021-09-28 13:51:30.457 CST [29540] LOG:  could not open tablespace directory "pg_tblspc/16870/PG_10_201707211": No such file or directory

但是这个怎么解决?有大神帮忙看看吗?


[此贴子已经被作者于2021-9-28 14:14编辑过]

搜索更多相关主题的帖子: code file directory service not 
2021-09-28 10:34
快速回复:pgsql10重启后,一直启动不了
数据加载中...
 
   



关于我们 | 广告合作 | 编程中国 | 清除Cookies | TOP | 手机版

编程中国 版权所有,并保留所有权利。
Powered by Discuz, Processed in 0.026180 second(s), 8 queries.
Copyright©2004-2024, BCCN.NET, All Rights Reserved