From: Chris Browne <cbbrowne@acm.org>
To: pgsql-admin@postgresql.org
Subject: Re: replica of database
Date: Thu, 11 Sep 2008 18:18:32 -0400
Message-ID: <87y71yxr5z.fsf@dba2.int.libertyrms.com> (raw)
References: <127B4898CB0EE64DA86CDB35C6713FB503000C0BE9@tsr-exch03>
<48C8A419.5060304@commandprompt.com>
<87wshizrdo.fsf@dba2.int.libertyrms.com>
<dcc563d10809111119gc3c076bo77e06f12eb4982f9@mail.gmail.com>
<1221163376.8188.43.camel@bnicholson-desktop>
bnichols@ca.afilias.info (Brad Nicholson) writes:
> 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.
Mind you, that was on 7.4, not 7.3.
It's possible that:
a) 7.4 did new stuff, so that those index corruptions would not have been
present in 7.3, but also that
b) 7.3 might have "data-eating problems not present in 7.4."
I *would* suggest using 1.1.[latest], of Slony-I, as that should have
the fewest issues, on the Slony-I side, of any version available to
run against PG 7.3, and should work the most cleanly.
But on the other hand, I'd *also* strongly urge using this to get off
of v7.3 and onto something a LOT newer, ASAP. I think you can get to
PostgreSQL 8.1 using the 1.1 branch, which is usefully newer :-).
--
let name="cbbrowne" and tld="acm.org" in String.concat "@" [name;tld];;
http://www3.sympatico.ca/cbbrowne/unix.html
Economists are still trying to figure out why the girls with the least
principle draw the most interest.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: cbbrowne@acm.org
Subject: Re: replica of database
In-Reply-To: <87y71yxr5z.fsf@dba2.int.libertyrms.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox