Dragos Valentin Moinescu <dragos.moinescu@xxxxxxxxx> 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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
