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 2EF3C11F6B58 for ; Fri, 14 Apr 2006 14:42:39 -0300 (ADT) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Score: 0 X-Spam-Level: X-Spam-Status: No, score=0 required=5 tests=[none] Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id bqv7bPc4F7E9 for ; Fri, 14 Apr 2006 14:42:35 -0300 (ADT) X-Greylist: delayed 04:46:14.188085 by SQLgrey- Received: from mail.nameshield.net (gatei2.nameshield.net [82.245.54.114]) by postgresql.org (Postfix) with ESMTP id E085411F61E1 for ; Fri, 14 Apr 2006 14:42:35 -0300 (ADT) Received: from localhost (mail.nameshield.net [127.0.0.1]) by mail.nameshield.net (Postfix) with ESMTP id A4F7E80E0; Fri, 14 Apr 2006 19:42:34 +0200 (CEST) Received: from mail.nameshield.net ([127.0.0.1]) by localhost (mail.nameshield.net [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 15930-06; Fri, 14 Apr 2006 19:42:30 +0200 (CEST) Received: from [192.168.2.110] (Pluton4.interne.observatoiredesmarques.fr [192.168.2.110]) by mail.nameshield.net (Postfix) with ESMTP id 123B1800F; Fri, 14 Apr 2006 19:42:29 +0200 (CEST) Message-ID: <443FDF05.4060600@laposte.net> Date: Fri, 14 Apr 2006 19:42:29 +0200 From: Pierre LEBRECH User-Agent: Mozilla Thunderbird 1.0.6 (X11/20050716) X-Accept-Language: en-us, en MIME-Version: 1.0 To: "Joshua D. Drake" CC: pgsql-admin@postgresql.org Subject: Re: Slony1 or DRBD for replication ? References: <443F9BF3.4060101@laposte.net> <1145028323.5597.1.camel@localhost.localdomain> In-Reply-To: <1145028323.5597.1.camel@localhost.localdomain> Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Debian amavisd-new at nameshield.net X-Archive-Number: 200604/131 X-Sequence-Number: 21300 Joshua D. Drake wrote: > 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 > The second location should be used in case of emergency. So, if my first machine/system becomes unreachable for whatever reason, I want to be able to switch very quickly to the other machine. Of course, the goal is to have no loss of data. That is the context. Furthermore, I have experience with DRBD (not on databases) and I do not know if DRBD would be the best way to solve this replication problem. Thanks for any suggestions and explanations. PS : my database is actualy in production in a critical environment > > >>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 >>