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