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 0293F52932 for ; Sat, 25 Jun 2005 12:50:47 -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 33464-05 for ; Sat, 25 Jun 2005 15:50:41 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id AE3135280D for ; Sat, 25 Jun 2005 12:50:41 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.13.1/8.13.1) with ESMTP id j5PFofQ9034919 for ; Sat, 25 Jun 2005 15:50:41 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.13.1/8.13.1/Submit) id j5PFo4Q3034777 for pgsql-admin@postgresql.org; Sat, 25 Jun 2005 15:50:04 GMT (envelope-from news) From: Christopher Browne X-Newsgroups: pgsql.admin Subject: Re: real time replication of pgsql database Date: Sat, 25 Jun 2005 11:44:37 -0400 Organization: cbbrowne Computing Inc Lines: 21 Message-ID: References: <20050625065107.65076.qmail@web8607.mail.in.yahoo.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: usenet@news.hub.org X-message-flag: Outlook is rather hackable, isn't it? X-Home-Page: http://www.cbbrowne.com/info/ X-Affero: http://svcs.affero.net/rm.php?r=cbbrowne User-Agent: Gnus/5.1007 (Gnus v5.10.7) XEmacs/21.4 (Jumbo Shrimp, linux) Cancel-Lock: sha1:8S9mhIvPyU+JbzhZxltlTqG8FSE= To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Archive-Number: 200506/211 X-Sequence-Number: 17966 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?