Help, server doesn't start

From: "Anibal David Acosta" <aa(at)devshock(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Help, server doesn't start
Date: 2012-06-25 02:53:27
Message-ID: 006b01cd527d$b483f970$1d8bec50$@devshock.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

We have an old postgres installation (8.3) running on windows 2003

The server run perfect for many years but today it crash L

We have a very old backup so I'll try desperate to repair.

If I can't repair I want to skip the error and start server with only
healthy data, no matter if I lose some table page, entire table or even
entire database because the server has many databases inside.

Currently the database is not starting, when I try to start I got the in the
log:

2012-06-25 02:22:33 GMT LOG: database system was interrupted while in
recovery at 2012-06-25 02:22:26 GMT

2012-06-25 02:22:33 GMT HINT: This probably means that some data is
corrupted and you will have to use the last backup for recovery.

2012-06-25 02:22:33 GMT LOG: database system was not properly shut down;
automatic recovery in progress

2012-06-25 02:22:33 GMT LOG: redo starts at 17C/E1C42040

2012-06-25 02:22:33 GMT LOG: loaded library
"$libdir/plugins/plugin_debugger.dll"

2012-06-25 02:22:33 GMT FATAL: the database system is starting up

[LAST TWO LINES REPEAT MANY TIMES]

2012-06-25 02:22:36 GMT LOG: startup process (PID 1120) was terminated by
exception 0xC000000D

2012-06-25 02:22:36 GMT HINT: See C include file "ntstatus.h" for a
description of the hexadecimal value.

2012-06-25 02:22:36 GMT LOG: aborting startup due to startup process
failure

2012-06-25 02:22:36 GMT FATAL: the database system is starting up

2012-06-25 02:22:36 GMT LOG: loaded library
"$libdir/plugins/plugin_debugger.dll"

2012-06-25 02:22:36 GMT FATAL: the database system is starting up

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tim Uckun 2012-06-25 03:37:54 Re: Hot standby streaming replication doesn't work
Previous Message David Johnston 2012-06-25 02:52:39 Re: Question about EXISTS