|
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 2009-03-31 2009-03-31 09:30:41 CDT LOG: loaded library
"$libdir/plugins/plugin_debugger.dll" 2009-03-31 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 2009-03-31 2009-03-31 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 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, |
