Re: 8.2 "real-time" recovery

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(dot)Grittner(at)wicourts(dot)gov> wrote:
> Dragos Valentin Moinescu <dragos(dot)moinescu(at)gmail(dot)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