From: John Sidney-Woollett <johnsw@wardbrook.com>
To: Robert Treat <xzilla@users.sourceforge.net>
Cc: johnsw@wardbrook.com, "Anthony Best" <abest@digitalflex.net>
Cc: pgsql-general@postgresql.org <pgsql-general@postgresql.org>
Subject: Re: Replication
Date: Thu, 18 Dec 2003 21:35:52 -0000 (GMT)
Message-ID: <1885.192.168.0.64.1071783352.squirrel@mercury.wardbrook.com> (raw)
In-Reply-To: <1071780044.1792.9028.camel@camel>
References: <3FDFAD8F.5080404@digitalflex.net>
<1294.192.168.0.64.1071647844.squirrel@mercury.wardbrook.com>
<1319.192.168.0.64.1071648485.squirrel@mercury.wardbrook.com>
<1339.192.168.0.64.1071648904.squirrel@mercury.wardbrook.com>
<1071780044.1792.9028.camel@camel>
Robert
Thanks for the info.
I'll keep the list posted with feedback after I decide which product to go
with.
John
Robert Treat said:
> Check out the pg_replicator project on gborg, IIRC it has links to some
> of the replication solutions.... USOGRES comes to mind...
>
> BTW - I'f you do give each one a twirl, we'd love to hear about your
> experiences.
>
> Robert Treat
>
> On Wed, 2003-12-17 at 03:15, John Sidney-Woollett wrote:
>> Apologies if this is a double post - I'm sure I sent a similar e-mail to
>> the list, but it seems to have disappeared in the ether.
>>
>> Id there a definitive list of what replication options are currently
>> available for 7.4 (and 7.5), and what their relative strengths and
>> weaknesses are; ease of use, configuration, cost, support etc
>>
>> I need to start tackling replication of our DB in the next few weeks,
>> and
>> wondered what the options are.
>>
>> I've seen RServer and Mammoth Replication - these look good (on paper)
>> but
>> both appear to involve a license fee (which is more than I have to spend
>> right now).
>>
>> Is pgReplication ready for 7.4 yet? And are there any other *free*
>> options? If not maybe I'll have to find the money for a commercial
>> solution.
>>
>> I'd appreciate any feedback from anyone who has a working replication
>> solution.
>>
>> Thanks
>>
>> John Sidney-Woollett
>>
>>
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 9: the planner will ignore your desire to choose an index scan if
>> your
>> joining column's datatypes do not match
>
> --
> Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
>
>
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-general@postgresql.org
Cc: johnsw@wardbrook.com, xzilla@users.sourceforge.net, abest@digitalflex.net
Subject: Re: Replication
In-Reply-To: <1885.192.168.0.64.1071783352.squirrel@mercury.wardbrook.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