Re: Help, server doesn't start

["Anibal David Acosta" <aa@xxxxxxxxxxxx>]

Yes, we must upgrade.

The value of the shared_preload_libraries is

 

shared_preload_libraries = '$libdir/plugins/plugin_debugger.dll'                               # (change requires restart)

 

An additional information….

When I login into the server the disk used by Postgres installation was without space (0Bytes available).

 

Also is possible that someone (I am checking now) restart the Postgres service in the middle of this situation

 

Right now I am making a file-level copy of the entire postgres folder in order to run some corruption recover method

 

Thanks!

 

 

De: Raghavendra [mailto:raghavendra.rao@enterprisedb.com]
Enviado el: lunes, 25 de junio de 2012 12:31 a.m.
Para: Anibal David Acosta
CC: pgsql-general@xxxxxxxxxxxxxx
Asunto: Re: Help, server doesn't start

 

 

On Mon, Jun 25, 2012 at 8:23 AM, Anibal David Acosta <aa@xxxxxxxxxxxx> 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/