X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 6DCBD11F7372 for ; Fri, 14 Apr 2006 12:25:37 -0300 (ADT) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Score: 0.111 X-Spam-Level: X-Spam-Status: No, score=0.111 required=5 tests=[AWL=0.111] Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id iyyIUFe5vbUe for ; Fri, 14 Apr 2006 12:25:32 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from projects.commandprompt.com (host-130.commandprompt.net [207.173.203.130]) by postgresql.org (Postfix) with ESMTP id 355B011F712A for ; Fri, 14 Apr 2006 12:25:31 -0300 (ADT) Received: from [192.168.15.50] (or-67-76-146-141.sta.sprint-hsd.net [67.76.146.141]) (authenticated bits=0) by projects.commandprompt.com (8.13.4/8.13.4) with ESMTP id k3EFPP9a020882; Fri, 14 Apr 2006 08:25:30 -0700 Subject: Re: Slony1 or DRBD for replication ? From: "Joshua D. Drake" To: Pierre LEBRECH Cc: pgsql-admin@postgresql.org In-Reply-To: <443F9BF3.4060101@laposte.net> References: <443F9BF3.4060101@laposte.net> Content-Type: text/plain Organization: Command Prompt, Inc. Date: Fri, 14 Apr 2006 08:25:23 -0700 Message-Id: <1145028323.5597.1.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.6.1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: ClamAV version 0.88, clamav-milter version 0.87 on projects.commandprompt.com X-Virus-Status: Clean X-Greylist: Sender succeded SMTP AUTH authentication, not delayed by milter-greylist-1.6 (projects.commandprompt.com [192.168.2.159]); Fri, 14 Apr 2006 08:25:31 -0700 (PDT) X-Archive-Number: 200604/130 X-Sequence-Number: 21299 On Fri, 2006-04-14 at 14:56 +0200, Pierre LEBRECH wrote: > Hello, > > I want to replicate my PostgreSQL database at an other location. The > distance between the two locations should be around 10 miles. The link > should be a fast ethernet dedicated link. > > What would you suggest me to do? DRBD or slony1 for PostgreSQL replication? It depends on your needs. If you want to be able to use the slave postgresql instance (reporting, non replicated name spaces, materialized views etc...) Slony or Mammoth Replicator. If you want to also replicate users/groups, grant and revoke, Mammoth Replicator. If you just want a hot backup... DRBD. Joshua D. Drake > > Thank you. > > ---------------------------(end of broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match > -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 Providing the most comprehensive PostgreSQL solutions since 1997 http://www.commandprompt.com/