Hello,
There are two heavily supported and active replication projects.
1. Slony - http://www.slony.info 2. Mammoth Replicator - http://www.commandprompt.com/
Slony is Open Source and uses triggers and a replication schema to replicate data.
Mammoth Replicator is commercial and uses a transaction log and a master control process to replicate data.
Slony replicates data every (10?) transactions. Mammoth Replicator replicates every transaction.
Mammoth is older than Slony and backed by my company Command Prompt, Inc.
Neither is slated to be "integrated" with PostgreSQL as they are both good products that serve different purposes.
Sincerely,
Joshua D. Drake
[EMAIL PROTECTED] wrote:
Hello
I am going to do a comparison betweem PgSQL and MySQL replication system.
I hear there are some replication projects available for PgSQL. Which are still active and serious, because I hear that some are not active or incomplete?
Will any of these projects be merged with PgSQL soon?
I appreciate all information.
Thank you.
Tim
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
-- Command Prompt, Inc., home of PostgreSQL Replication, and plPHP. Postgresql support, programming shared hosting and dedicated hosting. +1-503-667-4564 - [EMAIL PROTECTED] - http://www.commandprompt.com Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL
begin:vcard fn:Joshua D. Drake n:Drake;Joshua D. org:Command Prompt, Inc. adr:;;PO Box 215;Cascade Locks;Oregon;97014;USA email;internet:[EMAIL PROTECTED] title:Consultant tel;work:503-667-4564 tel;fax:503-210-0334 note:Command Prompt, Inc. is the largest and oldest US based commercial PostgreSQL support provider. We provide the only commercially viable integrated PostgreSQL replication solution, but also custom programming, and support. We authored the book Practical PostgreSQL, the procedural language plPHP, and adding trigger capability to plPerl. x-mozilla-html:FALSE url:http://www.commandprompt.com/ version:2.1 end:vcard
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
