X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 201D45E46DF for ; Fri, 6 Aug 2004 14:56:00 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 54868-04 for ; Fri, 6 Aug 2004 17:55:50 +0000 (GMT) Received: from hosting.commandprompt.com (128.commandprompt.com [207.173.200.128]) by svr1.postgresql.org (Postfix) with ESMTP id E2E975E46D3 for ; Fri, 6 Aug 2004 14:55:49 -0300 (ADT) Received: from [192.168.1.51] (dsl093-038-087.pdx1.dsl.speakeasy.net [66.93.38.87]) (authenticated) by hosting.commandprompt.com (8.11.6/8.11.6) with ESMTP id i76HtgJ27444; Fri, 6 Aug 2004 10:55:42 -0700 Message-ID: <4113C627.9030205@commandprompt.com> Date: Fri, 06 Aug 2004 10:55:51 -0700 From: "Joshua D. Drake" Organization: Command Prompt, Inc. User-Agent: Mozilla Thunderbird 0.7.1 (X11/20040626) X-Accept-Language: en-us, en MIME-Version: 1.0 To: schen@graciousstyle.com Cc: pgsql-general@postgresql.org Subject: Re: replication References: <4113BB1C.9020106@graciousstyle.com> In-Reply-To: <4113BB1C.9020106@graciousstyle.com> Content-Type: multipart/mixed; boundary="------------070001020702050904070207" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.5 tagged_above=0.0 required=5.0 tests=RAZOR2_CF_RANGE_11_50, RAZOR2_CHECK X-Spam-Level: * X-Archive-Number: 200408/227 X-Sequence-Number: 63782 This is a multi-part message in MIME format. --------------070001020702050904070207 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Hello, The two main replication products available are: Slony-I and Mammoth Replicator. Slony-I: Open Source, trigger based, batch replication. Mammoth Replicator: Closed Source (source license available), integrated (no triggers), live and batch replication. They are both good solutions (I work for the creators of Mammoth Replicator) that serve different purposes. Sincerely, Joshua D. Drake Si Chen wrote: > Hello everyone. > > Are there any recommended ways for doing postgresql replication? > Si Chen > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org -- Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC Postgresql support, programming shared hosting and dedicated hosting. +1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL --------------070001020702050904070207 Content-Type: text/x-vcard; charset=utf-8; name="jd.vcf" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="jd.vcf" 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:jd@commandprompt.com title:Consultant tel;work:503-667-4564 tel;fax:503-210-0034 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 --------------070001020702050904070207--