From: | "Samuel J(dot) Sutjiono" <ssutjiono(at)wc-group(dot)com> |
---|---|
To: | "Justin Clift" <justin(at)postgresql(dot)org> |
Cc: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Recovery Mode |
Date: | 2002-12-11 20:15:47 |
Message-ID: | 008c01c2a152$184e4c90$1abea818@headquarters.wcgroup.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)postgresql(dot)org>
To: "Samuel J. Sutjiono" <ssutjiono(at)wc-group(dot)com>
Cc: <pgsql-general(at)postgresql(dot)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(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
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas O'Connell | 2002-12-11 20:43:27 | 7.2.x -> 7.3 upgrade docs? |
Previous Message | Mark Wilson | 2002-12-11 19:58:02 | Re: infinity as a date |