X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 5D49F5672A for ; Tue, 22 Mar 2005 21:22:03 +0000 (GMT) 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 83591-06 for ; Tue, 22 Mar 2005 21:21:53 +0000 (GMT) Received: from hosting.commandprompt.com (128.commandprompt.com [207.173.200.128]) by svr1.postgresql.org (Postfix) with ESMTP id 5A3545652D for ; Tue, 22 Mar 2005 21:21:53 +0000 (GMT) Received: from 192.168.1.52 (fc1smp [66.93.38.87]) by hosting.commandprompt.com (8.12.8/8.12.8) with ESMTP id j2MLJ9kh007434; Tue, 22 Mar 2005 13:19:09 -0800 Subject: Re: Replication with PostgreSQL From: "Joshua D. Drake" Reply-To: jd@commandprompt.com To: Christopher Browne Cc: pgsql-admin@postgresql.org In-Reply-To: References: <4239952F.9070601@ritvi.com> Content-Type: text/plain Organization: Joshua D. Drake Date: Tue, 22 Mar 2005 13:21:52 -0800 Message-Id: <1111526512.21105.20.camel@jd2.commandprompt.com> Mime-Version: 1.0 X-Mailer: Evolution 2.0.2 (2.0.2-3) Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.276 tagged_above=0 required=5 tests=AWL, INFO_TLD X-Spam-Level: X-Archive-Number: 200503/362 X-Sequence-Number: 16860 On Sun, 2005-03-20 at 22:33 -0500, Christopher Browne wrote: > After a long battle with technology, prakash@ritvi.com (prakash sompura), an earthling, wrote: > > Can any one tell me how do I replicate my PostgreSql database from > > one server to another server? You can use Mammoth Replicator or Slony. Replicator can be found here: http://www.commandprompt.com/ Slony can be found here: http://www.slony.info Replicator is easier to setup and manage but it is not free. Sincerely, Joshua D. Drake > > One method involves using pg_dump to dump the state out, and load it > onto the other server. Certainly this is the simplest way to do a one > point in time replication. > > Another involves using the PG 8.0 "PITR" (Point In Time Recovery) > facility. > > If you want the replica to be relatively up to date and usable more or > less continuously as a queryable replica, then you should look into > one or another of the replication systems. Slony-I is the "hot name" > at this point... -- Command Prompt, Inc., Your PostgreSQL solutions company. 503-667-4564 Custom programming, 24x7 support, managed services, and hosting Open Source Authors: plPHP, pgManage, Co-Authors: plPerlNG Reliable replication, Mammoth Replicator - http://www.commandprompt.com/