Re: replica of database

Version 8.3 has pg_standby.  Does anyone know how well that works for failover?

--- On Thu, 9/11/08, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> wrote:

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
Subject: Re: [ADMIN] replica of database
To: "Joshua D. Drake" <jd(at)commandprompt(dot)com>
Cc: "Aftab Alam" <AAlam(at)tsrdarashaw(dot)com>, "Vishal Arora" <aroravishal22(at)hotmail(dot)com>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Date: Thursday, September 11, 2008, 12:22 AM

On Wed, Sep 10, 2008 at 10:52 PM, Joshua D. Drake <jd(at)commandprompt(dot)com>
wrote:
> Aftab Alam wrote:
>>
>> Yes ,I want a replica of my db so that I can use it as failover
>>
>>
>> Version 7.3 linux AS release 4 update 6
>
> Version 7.3 is end of life and I don't know of *any* of the
replication
> technologies that will work with it.

I think older versions of slony can talk to it, but I'd only use that
to upgrade in place to 8.3. I'm pretty sure you'd have to make a stop
at 8.0 or 8.1 along the way...