Обсуждение: non starting server
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.