i had a lot of debugging enabled. i went to create an index, and pgsql
dumped on me. i tried restarting several times - no luck.
starting postgresql gives:
LOG: database system shutdown was interrupted at 2004-07-16 01:11:56 EDT
LOG: checkpoint record is at 0/53A3FC0
LOG: redo record is at 0/53A3FC0; undo record is at 0/0; shutdown TRUE
LOG: next transaction id: 44321; next oid: 111535
LOG: database system was not properly shut down; automatic recovery in
progress
LOG: ReadRecord: unexpected pageaddr 0/33A4000 in log file 0, segment
5, offset 3817472
LOG: redo is not required [ OK ]
# PANIC: XLogWrite: write request 0/53A4000 is past end of log 0/53A4000
LOG: startup process (pid 16068) was terminated by signal 6
LOG: aborting startup due to startup process failure
this is 7.3.3 (PGDG rpm's) on red hat 7.2