Re: Help, server doesn't start

On Mon, Jun 25, 2012 at 8:23 AM, Anibal David Acosta <aa(at)devshock(dot)com>wrote:

> 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.****
>
> **
>
Side-by, you should also consider upgrading PG versions to latest.

> **
>
> ** **
>
> 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****
>
> ** **
>
> **
>
Can you also paste whats there in shared_preload_libraries setting from
$PGDATA/postgresql.conf ?

---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/