Thanx for your reply. Still, we are talking about 80G databases which are heavily used. I cannot wait for 9.0 (which is still in beta). I really need a solution ASAP. Where can I find information about how to modify the postgresql server in order to allow this in 8.2.17? Thank you On Wed, Aug 25, 2010 at 4:58 PM, Kevin Grittner <Kevin.Grittner@xxxxxxxxxxxx> wrote: > Dragos Valentin Moinescu <dragos.moinescu@xxxxxxxxx> wrote: > >> 8.2.3 production server > > http://www.postgresql.org/support/versioning > http://www.postgresql.org/docs/8.2/static/release.html > >> backup server ... that should keep updating hourly the db cluster >> based on WAL files received from production server > > http://www.postgresql.org/docs/8.2/interactive/warm-standby.html > > Starting with the 9.0 release (which is expected to be out next > month) you will be able to stream WAL data in near real-time and run > read-only queries on the standby. > > -Kevin > -- Best regards, Dragos Moinescu -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
