pgsql10重启后,一直启动不了
postgresql-10.service - PostgreSQL 10 database serverLoaded: 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编辑过]