postgresql意外中止，无法启动

PG数据库在使用过程中数据库突然中止，且无法启动，存在一些类似报错信息：

LOG:  checkpoints are occurring too frequently (7 seconds apart)HINT:  Consider increasing the configuration parameter "checkpoint_segments".PANIC:  could not write to file "pg_xlog/xlogtemp.9028": No space left on deviceSTATEMENT:  insert into t1 select generate_series(1,1000000),'nan',md5('highgo');PANIC:  could not write to file "pg_xlog/xlogtemp.9028": No space left on deviceserver closed the connection unexpectedlyThis probably means the server terminated abnormallybefore or while processing the request.The connection to the server was lost. Attempting reset: LOG:  server process (PID 9028) was terminated by signal 6: AbortedDETAIL:  Failed process was running: insert into t1 select * from t2;LOG:  terminating any other active server processesWARNING:  terminating connection because of crash of another server processDETAIL:  The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.HINT:  In a moment you should be able to reconnect to the database and repeat your command.Failed.!> LOG:  all server processes terminated; reinitializingLOG:  database system was interrupted; last known up at 2017-12-04 18:05:09 CSTLOG:  database system was not properly shut down; automatic recovery in progressLOG:  redo starts at 0/103FE040LOG:  redo done at 0/14FFFF68LOG:  last completed transaction was at log time 2017-12-04 18:05:09.85515+08PANIC:  could not write to file "pg_xlog/xlogtemp.9084": No space left on deviceLOG:  startup process (PID 9084) was terminated by signal 6: AbortedLOG:  aborting startup due to startup process failure--------------------LOG:  database system shutdown was interrupted; last known up at 2017-12-04 18:05:23 CSTLOG:  database system was not properly shut down; automatic recovery in progressLOG:  redo starts at 0/103FE040LOG:  redo done at 0/14FFFF68LOG:  last completed transaction was at log time 2017-12-04 18:05:09.85515+08PANIC:  could not write to file "pg_xlog/xlogtemp.9138": No space left on deviceLOG:  startup process (PID 9138) was terminated by signal 6: AbortedLOG:  aborting startup due to startup process failure

原因是存放wal日志所在文件系统空间不足。

清理该文件系统下过期的临时文件，或将wal日志存放至更大的系统空间中。

By 徐云鹤