"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