Justin,
I think I found out the cause of the crash. When I restarted the db, I
specified invalid data directory as indicated in the logfile.
The database has been in recovery mode for about three hours. Why is it
doing that ? Is is safe to restart the database ?
Thanks for your help.
Regards,
Sam
----- Original Message -----
From: "Justin Clift" <justin@postgresql.org>
To: "Samuel J. Sutjiono" <ssutjiono@wc-group.com>
Cc: <pgsql-general@postgresql.org>
Sent: Wednesday, December 11, 2002 2:57 PM
Subject: Re: [GENERAL] Recovery Mode
> Samuel J. Sutjiono wrote:
> > Hi,
> >
> > My database crashed and I received the following message..... psql:
FATAL
> > 1: The database system is in recovery mode
> > Can anyone advise me on what I need to do to restore the database ?
>
> Hi Samuel,
>
> It means the database is repairing itself before going live. If
everything comes back together fine, then you shouldn't
> have lost anything.
>
> If there are further problems, it will let you know and will require you
to fix them before it will start.
>
>
> > and also tell me what might have caused the crash ?
>
> Hopefully there is info about it in the log file.
>
> You'd probably want to look there first and see if there is anything
obvious.
>
> Any ideas of what was accessing the database at the time of the crash?
>
> :-)
>
> Regards and best wishes,
>
> Justin Clift
>
>
> > I appreciate any help.
> >
> > Regards,
> > Sam
> >
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 2: you can get off all lists at once with the unregister command
> > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
>
> --
> "My grandfather once told me that there are two kinds of people: those
> who work and those who take the credit. He told me to try to be in the
> first group; there was less competition there."
> - Indira Gandhi
>
>
>