Re: 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(at)postgresql(dot)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