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 72A125294F for ; Mon, 27 Jun 2005 11:19:15 -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 17065-06 for ; Mon, 27 Jun 2005 14:19:04 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 156D252862 for ; Mon, 27 Jun 2005 11:19:03 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j5REJ1LL006246; Mon, 27 Jun 2005 10:19:01 -0400 (EDT) To: Bruce Momjian Cc: Martin Fandel , pgsql-admin@postgresql.org Subject: Re: DRDB? In-reply-to: <200506270945.j5R9jhM12625@candle.pha.pa.us> References: <200506270945.j5R9jhM12625@candle.pha.pa.us> Comments: In-reply-to Bruce Momjian message dated "Mon, 27 Jun 2005 05:45:43 -0400" Date: Mon, 27 Jun 2005 10:19:00 -0400 Message-ID: <6245.1119881940@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200506/231 X-Sequence-Number: 17986 Bruce Momjian writes: > Martin Fandel wrote: >> is DRDB (http://www.drbd.org/) a recommended replication-solution for >> PostgreSQL? I asked some PostgreSQL-People and DRDB-People on the >> Linux-Tag in germany. But I'm not very assured about this solution. > Uh, we really don't _recommend_ replication solutions. However, I will > say I have heard of Slony, but never of DRDB. It seems DRDB replicates > the file system blocks to another machine. I have not probed further than the site's top page, but unless DRBD offers some pretty strong guarantees about physical write order on the master being duplicated on the slave, it won't work reliably for Postgres. regards, tom lane