Re: Recovery Mode

"Samuel J. Sutjiono" <ssutjiono@wc-group.com> writes:
> The database has been in recovery mode for about three hours.

In that case you probably have a problem :-(.  Ordinarily I'd expect the
recovery process runtime to not exceed the checkpoint interval, which is
5 minutes unless you changed it.  It sounds like the thing may be in
some kind of infinite loop.  What is showing up in the postmaster log?

            regards, tom lane