Re: pg replication tools? - Mailing list pgsql-performance

From Christopher Browne
Subject Re: pg replication tools?
Date
Msg-id m3pt1sqf5l.fsf@knuth.knuth.cbbrowne.com
Whole thread Raw
In response to pg replication tools?  (sarlav kumar <sarlavk@yahoo.com>)
List pgsql-performance
Clinging to sanity, jd@commandprompt.com ("Joshua D. Drake") mumbled into her beard:
> sarlav kumar wrote:
>
>> Hi all,
>>  Which is the best available PG replication tool in market now?
>
> There is no "best", there is only best for your situation. The two
> most supported are:
>
>
>>     * Mammoth PostgreSQL Replicator      * Slony-I
>>
>> Which one of these is a good option for replicating Postgres 7.3.2?
>>
>
> Mammoth PostgreSQL Replicator will automatically upgrade you to
> 7.3.8 which you should be running anyway.
>
> I believe Slony will work with 7.3.2.

No, it won't.

I believe there was something about namespace support that did not
stabilize until PostgreSQL 7.3.3, and Slony-I works with that version,
at the earliest.

And you're quite right; "best" is a slippery metric.  Like many
things, it may be altered by perspective.
--
If this was helpful, <http://svcs.affero.net/rm.php?r=cbbrowne> rate me
http://www3.sympatico.ca/cbbrowne/postgresql.html
I can see clearly now, the brain is gone...

pgsql-performance by date:

Previous
From: "Iain"
Date:
Subject: Re: Normalization or Performance
Next
From: "Vishal Kashyap @ [SaiHertz]"
Date:
Subject: Re: pg replication tools?