Here is a good overview. http://jeremy.zawodny.com/blog/archives/000846.html
Note that http://pgreplicator.sourceforge.net/ is a multi-master solution using TCL. Despite the dire home page, it is "actively" supported. However, our experience with it was that it was not industrial strenght. We aren't TCL experts though, so maybe that would have helped. --Ted --- "Joshua D. Drake" <[EMAIL PROTECTED]> wrote: > 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 > _______________________________ Do you Yahoo!? Declare Yourself - Register online to vote today! http://vote.yahoo.com ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
