corrupted pg_xlog/0000000000000000
От | Scott Parish |
---|---|
Тема | corrupted pg_xlog/0000000000000000 |
Дата | |
Msg-id | 20010227012955.C27362@aspen.srparish.net обсуждение исходный текст |
Ответы |
Re: corrupted pg_xlog/0000000000000000
|
Список | pgsql-general |
I have a production database running postgresql 7.1beta4. Everything was great untill '/etc/rc.d/init.d/pgsql stop' was ran. Now when ever a person makes an attempt to start the database postmaster refuses to start saying: DEBUG: starting up DEBUG: database system was interrupted at 2001-02-26 14:34:09 DEBUG: CheckPoint record at (0, 5962224) FATAL 2: Invalid RMID in checkPoint record DEBUG: proc_exit(2) DEBUG: shmem_exit(2) DEBUG: exit(2) /apps/pgsql/bin/postmaster: reaping dead processes... Startup failed - abort After doing a lot of probing around it appears that all the base/* files and global/* files are fine, however these seem to be useless without the pg_xlog/0000000000000000 file, which appears to contain the structure for the tables of the database. Are there any suggestions on how i may go about recovering from this incident without starting from scratch? Thank sRp -- Scott Parish http://srparish.net/
В списке pgsql-general по дате отправления: