[pgsql-jp: 39577] 起動に失敗します

["藤井律男/Ritsuo Fu]

藤井@岡山といいます。
お世話になります。

PostgreSQL7.4.7/Debian Sargeを使っています。

本日、デイスク障害でシステムが停止しました。
FSCK を使用して復旧後、postmasterを起動するのでが、
下記のメッセージが出て起動しませんでした。

過去のログを探してみましたが、同様のエラーを見つける
ことが出来ませんでした

sarge:/home/db# /etc/init.d/postgresql start
Starting PostgreSQL database server: postmaster(FAILED)
ERROR: ERROR: PostgreSQL postmaster did not start because of an unknown reason.
PostgreSQL's init script (/etc/init.d/postgresql) attempted
to start the postmaster, however, this failed because of an unknown
reason.
 
This should not happen and is a serious problem. Please examine the
situation (please take a look at the log files). If you know the
reason why it failed and, then please file a bug report to Debian
(unless the reason is something obvious like a full disk).

Debian PostgreSQL


postgresql.log には

FATAL:  terminating connection due to administrator command
LOG:  checkpoint record is at A/2EE37DB0
LOG:  redo record is at A/2EE37DB0; undo record is at 0/0; shutdown TRUE
LOG:  next transaction ID: 2668522; next OID: 11032757
LOG:  database system is ready
LOG:  received fast shutdown request
LOG:  shutting down
LOG:  database system is shut down
LOG:  database system was shut down at 2008-09-12 07:52:24 JST
LOG:  checkpoint record is at A/2EE37DF0
LOG:  redo record is at A/2EE37DF0; undo record is at 0/0; shutdown TRUE
LOG:  next transaction ID: 2668522; next OID: 11032757
LOG:  database system is ready
LOG:  received fast shutdown request
LOG:  shutting down
LOG:  database system is shut down
LOG:  database system was interrupted at 2008-09-12 11:42:06 JST
LOG:  could not open file "/tmp/SlaveDisk/var/lib/postgres/data/pg_xlog/00000003
00000080" (log file 3, segment 128): No such file or directory
LOG:  invalid primary checkpoint record
LOG:  could not open file "/tmp/SlaveDisk/var/lib/postgres/data/pg_xlog/00000003
00000080" (log file 3, segment 128): No such file or directory
LOG:  invalid secondary checkpoint record
PANIC:  could not locate a valid checkpoint record


エラーの回避方法をご存知の方がいらっしゃいましたら
アドバイスをいただければと思っております。


Ritsuo Fujii <ritsuo＠mxy.mesh.ne.jp>