non starting server - Mailing list pgsql-general

Long time reader, first time poster J

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.