Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 21D0164FCD6 for ; Thu, 11 Sep 2008 17:03:01 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 09024-01 for ; Thu, 11 Sep 2008 17:02:58 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from vgateway.libertyrms.info (vgateway.libertyrms.info [207.219.45.62]) by postgresql.org (Postfix) with ESMTP id 5F12364FCD2 for ; Thu, 11 Sep 2008 17:02:58 -0300 (ADT) Received: from dba5.int.libertyrms.com ([10.1.3.44]) by vgateway.libertyrms.info with esmtp (Exim 4.22) id 1KdsNU-0004de-H0 for pgsql-admin@postgresql.org; Thu, 11 Sep 2008 16:02:56 -0400 Subject: Re: replica of database From: Brad Nicholson To: pgsql-admin@postgresql.org In-Reply-To: References: <127B4898CB0EE64DA86CDB35C6713FB503000C0BE9@tsr-exch03> <48C8A419.5060304@commandprompt.com> <87wshizrdo.fsf@dba2.int.libertyrms.com> Content-Type: text/plain; charset=UTF-8 Date: Thu, 11 Sep 2008 16:02:56 -0400 Message-Id: <1221163376.8188.43.camel@bnicholson-desktop> Mime-Version: 1.0 X-Mailer: Evolution 2.22.3.1 Content-Transfer-Encoding: quoted-printable X-SA-Exim-Mail-From: bnichols@ca.afilias.info X-SA-Exim-Scanned: No; SAEximRunCond expanded to false X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200809/110 X-Sequence-Number: 30203 On Thu, 2008-09-11 at 12:19 -0600, Scott Marlowe wrote: > On Thu, Sep 11, 2008 at 8:30 AM, Chris Browne 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. > > >=20 > 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. --=20 =EF=BB=BFBrad Nicholson 416-673-4106 Database Administrator, Afilias Canada Corp.