报错日志截取

2021-04-20 11:23:57.289 HKT [16060] LOG: startup process (PID 13728) exited with exit code 1
2021-04-20 11:23:57.289 HKT [16060] LOG: aborting startup due to startup process failure
2021-04-20 11:23:57.292 HKT [16060] LOG: database system is shut down
2021-04-20 11:25:14.712 HKT [8152] LOG: starting PostgreSQL 12.5, compiled by Visual C++ build 1914, 64-bit
2021-04-20 11:25:14.715 HKT [8152] LOG: listening on IPv6 address "::", port 30007
2021-04-20 11:25:14.716 HKT [8152] LOG: listening on IPv4 address "0.0.0.0", port 30007
2021-04-20 11:25:14.768 HKT [8152] LOG: could not open directory "pg_tblspc": No such file or directory
2021-04-20 11:25:14.993 HKT [14264] LOG: database system was shut down at 2021-04-19 15:51:47 HKT
2021-04-20 11:25:15.006 HKT [14264] LOG: could not open directory "pg_tblspc": No such file or directory
2021-04-20 11:25:15.008 HKT [14264] FATAL: could not open directory "pg_replslot": No such file or directory

问题分析

该问题是因为程序异关闭（台式机突然断电，笔记本不关闭程序的情况下直接关机），导致 postgresql 数据库部分空白文件夹丢失

丢失的文件夹一般为随机空白的文件夹，具体查看eview-server\log\postgres.log

解决办法

在eview-server\pgdata\目录下创建日志中报错的文件夹 pg_tblspc，pg_replslot,具体需要创建的文件夹看日志，哪个文件夹丢失了。

正常情况下postgresql数据库的pgdata文件如下：