invalid primary checkpoint record

From: zhicheng wang <wang_zc(at)yahoo(dot)co(dot)uk>
To: pgsql-general(at)postgresql(dot)org
Subject: invalid primary checkpoint record
Date: 2006-06-28 11:06:23
Message-ID: 20060628110623.59543.qmail@web25607.mail.ukl.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

dear all

we have the following issues and cannot start the
postgresql server:

postgresql 8.0.5
redhat EL WS4 U3

the computer was shutdown properly. then the user
restarted the computer, in the middle of rebooting, he
switched off the power button on the wall. after that
we cannot start the database server any more. the
following is the log. please help.

thanks
cheng

LOG: database system shutdown was interrupted at
2006-06-26 10:33:11 BST
LOG: could not open file
"/var/lib/pgsql/data/pg_xlog/000000010000000000000000"
(log file 0, segment 0): No such file or directory
LOG: invalid primary checkpoint record
LOG: could not open file
"/var/lib/pgsql/data/pg_xlog/000000010000000000000000"
(log file 0, segment 0): No such file or directory
LOG: invalid secondary checkpoint record
PANIC: could not locate a valid checkpoint record
LOG: startup process (PID 29959) was terminated by
signal 6
LOG: aborting startup due to startup process failure
LOG: logger shutting down
LOG: database system shutdown was interrupted at
2006-06-26 10:33:11 BST
LOG: could not open file
"/var/lib/pgsql/data/pg_xlog/000000010000000000000000"
(log file 0, segment 0): No such file or directory
LOG: invalid primary checkpoint record
LOG: could not open file
"/var/lib/pgsql/data/pg_xlog/000000010000000000000000"
(log file 0, segment 0): No such file or directory
LOG: invalid secondary checkpoint record
PANIC: could not locate a valid checkpoint record
LOG: startup process (PID 30015) was terminated by
signal 6
LOG: aborting startup due to startup process failure
LOG: logger shutting down

Euro-China Medlink ltd
http://www.euro-china.co.uk


___________________________________________________________
Now you can scan emails quickly with a reading pane. Get the new Yahoo! Mail. http://uk.docs.yahoo.com/nowyoucan.html

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Hallgren 2006-06-28 11:56:47 Re: UUID's as primary keys
Previous Message Martijn van Oosterhout 2006-06-28 10:53:10 Re: UUID's as primary keys