"surabhi.ahuja" <[EMAIL PROTECTED]> writes:
> <2006-05-24 16:21:28 CDT%>LOG: database system was shut down at =
> 2006-05-24 16:01:00 CDT
> <2006-05-24 16:21:28 CDT%>LOG: record with zero length at 0/AC92BC
> <2006-05-24 16:21:28 CDT%>LOG: invalid primary checkpoint record
> <2006-05-24 16:21:28 CDT%>LOG: record with zero length at 0/AC9280
> <2006-05-24 16:21:28 CDT%>LOG: invalid secondary checkpoint record
> <2006-05-24 16:21:28 CDT%>PANIC: could not locate a valid checkpoint =
> record
> <2006-05-24 16:21:28 CDT%>LOG: startup process (PID 8428) was =
> terminated by signal 6
Hm, those are remarkably small values of the checkpoint record pointers;
roughly what you'd see immediately after initdb. What's the history of
this installation? If it's not freshly initdb'd, the only thing I can
think is that somebody has restored an old version of pg_control into
the directory tree. Which would be a pretty bad move, but maybe you can
recover with pg_resetxlog.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
