Long time reader, first time poster :-)
Postgresql 8.3.something
Windows Server 2003
So, the hard drive filled up this morning but server was still up. I
ran a few deletes some of them finished then the server crashed. Now it
won't start back up. Just getting could not start server on the command
line. According to the google I think I may need to run pg_resetxlog.
I'm a little nervous about running that though as this is a 450ish gig
database that has been going through some restructuring lately and I'm
not confident our backup is up to date.
Log is below also with pg_resetxlog -n. I'm wondering if any one has
other ideas or a reason why I shouldn't try pg_resetxlog.
Log says this...
2009-03-31 09:30:41 CDT LOG: database system was interrupted while in
recovery at 2009-03-31 08:47:54 CDT
2009-03-31 09:30:41 CDT HINT: This probably means that some data is
corrupted and you will have to use the last backup for recovery.
2009-03-31 09:30:41 CDT LOG: loaded library
"$libdir/plugins/plugin_debugger.dll"
2009-03-31 09:30:41 CDT LOG: database system was not properly shut
down; automatic recovery in progress
2009-03-31 09:30:41 CDT FATAL: the database system is starting up
2009-03-31 09:30:41 CDT LOG: redo starts at 5AB/E3003DC0
2009-03-31 09:30:42 CDT LOG: loaded library
"$libdir/plugins/plugin_debugger.dll"
...
2009-03-31 09:30:53 CDT LOG: could not open file
"pg_xlog/00000001000005AB000000E8" (log file 1451, segment 232): No such
file or directory
...
2009-03-31 09:53:00 CDT LOG: received fast shutdown request
2009-03-31 09:55:05 CDT LOG: received immediate shutdown request
2009-03-31 10:07:27 CDT LOG: database system was interrupted while in
recovery at 2009-03-31 09:30:41 CDT
2009-03-31 10:07:27 CDT HINT: This probably means that some data is
corrupted and you will have to use the last backup for recovery.
2009-03-31 10:07:27 CDT LOG: database system was not properly shut
down; automatic recovery in progress
2009-03-31 10:07:27 CDT LOG: redo starts at 5AB/E3003DC0
2009-03-31 10:07:28 CDT LOG: loaded library
"$libdir/plugins/plugin_debugger.dll"
2009-03-31 10:07:28 CDT FATAL: the database system is starting up
2009-03-31 10:07:28 CDT LOG: could not open file
"pg_xlog/00000001000005AB000000E8" (log file 1451, segment 232): No such
file or directory
...
2009-03-31 10:07:30 CDT LOG: loaded library
"$libdir/plugins/plugin_debugger.dll"
2009-03-31 10:07:30 CDT FATAL: the database system is starting up
2009-03-31 10:07:31 CDT LOG: startup process (PID 2336) was terminated
by exception 0xC000000D
2009-03-31 10:07:31 CDT HINT: See C include file "ntstatus.h" for a
description of the hexadecimal value.
2009-03-31 10:07:31 CDT LOG: aborting startup due to startup process
failure
2009-03-31 10:07:31 CDT LOG: loaded library
"$libdir/plugins/plugin_debugger.dll"
2009-03-31 10:07:31 CDT FATAL: the database system is starting up
pg_resetxlog -n
mapped win32 error code 2 to 2pg_control values:
First log file ID after reset: 1451
First log file segment after reset: 232
pg_control version number: 833
Catalog version number: 200711281
Database system identifier: 5194713519237881468
Latest checkpoint's TimeLineID: 1
Latest checkpoint's NextXID: 0/552938947
Latest checkpoint's NextOID: 37828980
Latest checkpoint's NextMultiXactId: 1
Latest checkpoint's NextMultiOffset: 0
Maximum data alignment: 8
Database block size: 8192
Blocks per segment of large relation: 131072
WAL block size: 8192
Bytes per WAL segment: 16777216
Maximum length of identifiers: 64
Maximum columns in an index: 32
Maximum size of a TOAST chunk: 1996
Date/time type storage: floating-point numbers
Maximum length of locale name: 128
LC_COLLATE: English_United States.1252
LC_CTYPE: English_United States.1252
Thanks,
Bradley Russell
Programmer
NPC International
------------------------------------------------------------------------
------------
NOTICE: This electronic mail message and any attached files are
confidential. The information is exclusively for the use of the
individual or entity intended as the recipient. If you are not the
intended recipient, any use, copying, printing, reviewing, retention,
disclosure, distribution or forwarding of the message or any attached
file is not authorized and is strictly prohibited. If you have received
this electronic mail message in error, please advise the sender by reply
electronic mail immediately and permanently delete the original
transmission, any attachments, and any copies of this message from your
computer system.