Re: 8.2 "real-time" recovery

Dragos Valentin Moinescu <dragos.moinescu@gmail.com> wrote:

> Where can I find information about how to modify the postgresql
> server in order to allow this in 8.2.17?

You haven't exactly said what "this" is, but I am inferring that you
want to bring your standby up to run read-only queries once per
hour, and then resume replication?  If so, you could either consider
one of the many replication solutions:

http://wiki.postgresql.org/wiki/Replication%2C_Clustering%2C_and_Connection_Pooling

or you could follow your current practice, but get a fresh base
backup each time, and start the warm standby over again.  If you use
rsync with a daemon you will probably be surprised how quickly you
can acquire the new base backup.

-Kevin