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 1B77C52875 for ; Sun, 26 Jun 2005 14:30:53 -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 95421-02 for ; Sun, 26 Jun 2005 17:30:44 +0000 (GMT) Received: from flake.decibel.org (flake.decibel.org [67.100.216.10]) by svr1.postgresql.org (Postfix) with ESMTP id 27C0752988 for ; Sun, 26 Jun 2005 14:30:43 -0300 (ADT) Received: by flake.decibel.org (Postfix, from userid 1001) id 52F731522B; Sun, 26 Jun 2005 12:30:43 -0500 (CDT) Date: Sun, 26 Jun 2005 12:30:43 -0500 From: "Jim C. Nasby" To: Christopher Browne Cc: pgsql-admin@postgresql.org Subject: Re: real time replication of pgsql database Message-ID: <20050626173043.GY89438@decibel.org> References: <20050625065107.65076.qmail@web8607.mail.in.yahoo.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: X-Operating-System: FreeBSD 4.11-RELEASE-p10 i386 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.9i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.245 tagged_above=0 required=5 tests=AWL, INFO_TLD X-Spam-Level: X-Archive-Number: 200506/222 X-Sequence-Number: 17977 You should also look at http://pgfoundry.org/projects/pgcluster/ On Sat, Jun 25, 2005 at 11:44:37AM -0400, Christopher Browne wrote: > Centuries ago, Nostradamus foresaw when hellz_waren@yahoo.co.in (hellz waren) would write: > > we are designing a heavy duty database in pgsql that > > expects to grow at an average of 100 MB spread over > > tables of 250 tables. > > > > We require always on database (24 X 7) database. And > > if one fails, the other one needs to start up. > > > > Could you someone tell me if there's any open source > > project that enables real time replication of data > > back up. > > I can use heartbeat, mon etc then to awake the other > > server if the main server is down. > > You might want to look into Slony-I; it can do this sort of thing. > > Version 1.1.0 was released on Thursday... > -- > wm(X,Y):-write(X),write('@'),write(Y). wm('cbbrowne','gmail.com'). > http://slony.info > Who's afraid of ARPA? > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org > -- Jim C. Nasby, Database Consultant decibel@decibel.org Give your computer some brain candy! www.distributed.net Team #1828 Windows: "Where do you want to go today?" Linux: "Where do you want to go tomorrow?" FreeBSD: "Are you guys coming, or what?"