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@wicourts.gov> wrote:
> Dragos Valentin Moinescu <dragos.moinescu@gmail.com> 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