X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 9CD5DD1BAD1 for ; Tue, 20 Apr 2004 08:36:16 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 87066-03 for ; Tue, 20 Apr 2004 08:36:17 -0300 (ADT) Received: from fep04-mail.bloor.is.net.cable.rogers.com (fep04-mail.bloor.is.net.cable.rogers.com [66.185.86.74]) by svr1.postgresql.org (Postfix) with ESMTP id D8371D1B8BB for ; Tue, 20 Apr 2004 08:36:13 -0300 (ADT) Received: from phlogiston.dydns.org ([65.49.125.184]) by fep04-mail.bloor.is.net.cable.rogers.com (InterMail vM.5.01.05.12 201-253-122-126-112-20020820) with ESMTP id <20040420113422.BYOV47745.fep04-mail.bloor.is.net.cable.rogers.com@phlogiston.dydns.org> for ; Tue, 20 Apr 2004 07:34:22 -0400 Received: by phlogiston.dydns.org (Postfix, from userid 1000) id EF9723D2B; Tue, 20 Apr 2004 07:35:34 -0400 (EDT) Date: Tue, 20 Apr 2004 07:35:34 -0400 From: Andrew Sullivan To: pgsql-admin@postgresql.org Subject: Re: Data replication Message-ID: <20040420113534.GB29715@phlogiston.dyndns.org> Mail-Followup-To: pgsql-admin@postgresql.org References: <4084DA6C.9080108@csd.uoc.gr> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <4084DA6C.9080108@csd.uoc.gr> User-Agent: Mutt/1.5.5.1+cvs20040105i X-Authentication-Info: Submitted using SMTP AUTH LOGIN at fep04-mail.bloor.is.net.cable.rogers.com from [65.49.125.184] using ID at Tue, 20 Apr 2004 07:34:22 -0400 X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.1 tagged_above=0.0 required=5.0 tests=RCVD_IN_SORBS X-Spam-Level: X-Archive-Number: 200404/259 X-Sequence-Number: 13232 On Tue, Apr 20, 2004 at 11:08:12AM +0300, GP wrote: > Hi all, > > I am quite new in Postgresql and I am wondering if it supports data > replication. Yes. There are several projects supporting it, some in contrib/ and some on the gborg.postgresql.org site. My employer, Afilias uses erserver today, and that is available from the gborg site. It's a pain to administer, and there are a number of fairly significant limitations, but it works. Note that I do not speak for my employer. Afilias is also supporting a new project, Slony-I, also available from the gborg site. IT'S NOT READY YET, but the work is progressing quickly (thanks to my colleague Jan Wieck), and if you're just starting a project which will go to production in 6 months' time or more, I'd suggest starting with Slony right now. Don't use it in production, yet, however. I think it's safe to say that it isn't ready for that. A -- Andrew Sullivan | ajs@crankycanuck.ca In the future this spectacle of the middle classes shocking the avant- garde will probably become the textbook definition of Postmodernism. --Brad Holland