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.