Skip site navigation (1) Skip section navigation (2)

Re: 8.2 "real-time" recovery

From: Dragos Valentin Moinescu <dragos(dot)moinescu(at)gmail(dot)com>
To: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: 8.2 "real-time" recovery
Date: 2010-08-25 14:04:56
Message-ID: AANLkTikrtDP+nHwzqfPNB0VOuGSnGg_3kN9QxTTpGrD5@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
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

In response to

Responses

pgsql-admin by date

Next:From: Kevin GrittnerDate: 2010-08-25 14:14:17
Subject: Re: 8.2 "real-time" recovery
Previous:From: Kevin GrittnerDate: 2010-08-25 13:58:00
Subject: Re: 8.2 "real-time" recovery

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group