Re: replica of database - Mailing list pgsql-admin

From Brad Nicholson
Subject Re: replica of database
Date
Msg-id 1221163376.8188.43.camel@bnicholson-desktop
Whole thread Raw
In response to Re: replica of database  ("Scott Marlowe" <scott.marlowe@gmail.com>)
List pgsql-admin
On Thu, 2008-09-11 at 12:19 -0600, Scott Marlowe wrote:
> On Thu, Sep 11, 2008 at 8:30 AM, Chris Browne <cbbrowne@acm.org> wrote:
> > jd@commandprompt.com ("Joshua D. Drake") writes:
> >> 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.
> >
> > Slony-I version 1.1 can still work with 7.3.  We ceased support of 7.3
> > when we released v1.2, but recommended, at the time, using 1.1 for
> > 7.3-compatibility.
> >
>
> And as  buggy as slony 1.0 might have been, I ran it for about 2 years
> in production replicating a HUGE amount of data daily with zero
> failures. Of course, the servers were fast and reliable, so that might
> have helped cover a lot of issues other people had for us.

And when we ran it we had replica's getting corrupted due to bugs almost
weekly (based on a particular pattern of activity).  The edges are
there.  It did never lose data on us.

--
Brad Nicholson  416-673-4106
Database Administrator, Afilias Canada Corp.


pgsql-admin by date:

Previous
From: "Peter Koczan"
Date:
Subject: Re: Postgres 8.3.3, GSSAPI, and Windows XP
Next
From: Chris Browne
Date:
Subject: Re: replica of database