"Samuel J. Sutjiono" <ssutjiono(at)wc-group(dot)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