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 BD1169DCB54 for ; Thu, 19 Jan 2006 17:00:12 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 04074-03-3 for ; Thu, 19 Jan 2006 17:00:08 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id 3FBEC9DCAC9 for ; Thu, 19 Jan 2006 17:00:05 -0400 (AST) Received: by noel.decibel.org (Postfix, from userid 1001) id B268A3982E; Thu, 19 Jan 2006 15:00:06 -0600 (CST) Date: Thu, 19 Jan 2006 15:00:06 -0600 From: "Jim C. Nasby" To: Juan Miguel Cc: Postgres Subject: Re: Distributed database with postgres Message-ID: <20060119210006.GD78403@pervasive.com> References: <43CFA641.4090107@ono.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <43CFA641.4090107@ono.com> X-Operating-System: FreeBSD 6.0-RELEASE amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.11 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.098 required=5 tests=[AWL=0.098] X-Spam-Score: 0.098 X-Spam-Level: X-Archive-Number: 200601/230 X-Sequence-Number: 20318 On Thu, Jan 19, 2006 at 03:46:25PM +0100, Juan Miguel wrote: > Hello, > > First of all, sorry about my english. I'm searching a tool for > implementing a distributed DB in postgres. I've found "pgreplicator" > (http://pgreplicator.sourceforge.net/). I figure out that the last > revision of the project was in 2001, and I don't know if the project > goes on. > > I have not tested pgreplicator yet, but I would know what do you think > about this software (if you know it) or other ones that give you the way > for mounting a distributed DB. > > I have found Slony, but it is a master / slave replication system, and I > think it cannot works as a pure distributed DB. > > By other way, what do you think about the state of the distributed DB > tools for postgres ? > What distributed DB tools for postgres exist ? > Are matures ? > What are their fails ? Currently your only options for multi-master OSS replication are all based on query replication, which has some very serious drawbacks (ie: how do you deal with now()). Your best bet is probably to wait for Slony-2; it sounds like it's pretty much exactly what you'd want, unless you need to support remote, disconnected clients, which I don't think it will handle well. -- Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461