PostgreSQL 8.0.10 にて
ひぇええええ〜。
2007-02-01 04:21:32 JST [856] LOG: database system shutdown was interrupted at 2007-02-01 04:07:46 JST 2007-02-01 04:21:32 JST [856] LOG: checkpoint record is at 4A/AA4DD48 2007-02-01 04:21:32 JST [856] LOG: redo record is at 4A/AA4DD48; undo record is at 0/0; shutdown FALSE 2007-02-01 04:21:32 JST [856] LOG: next transaction ID: 368356072; next OID: 31 3539590 2007-02-01 04:21:32 JST [856] LOG: database system was not properly shut down; automatic recovery in progress 2007-02-01 04:21:32 JST [856] LOG: redo starts at 4A/AA4DD84 2007-02-01 04:21:34 JST [856] LOG: could not open file "/var/lib/pgsql/data/pg_ xlog/000000010000004A00000013" (log file 74, segment 19): No such file or direct ory 2007-02-01 04:21:34 JST [856] LOG: redo done at 4A/12FFD3B4 2007-02-01 04:21:46 JST [853] LOG: startup process (PID 856) was terminated by signal 9 2007-02-01 04:21:46 JST [853] LOG: aborting startup due to startup process fail ure 2007-02-01 04:21:46 JST [855] LOG: logger shutting down
起動しなくなりました・・・。
しかたがないので、ログ削除。
pg_resetxlog -f /var/lib/pgsql/data