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 CDD689DC833 for ; Thu, 29 Dec 2005 10:55:30 -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 35515-04 for ; Thu, 29 Dec 2005 10:55:34 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from smtp.nildram.co.uk (smtp.nildram.co.uk [195.112.4.54]) by postgresql.org (Postfix) with ESMTP id 0D81C9DC818 for ; Thu, 29 Dec 2005 10:55:27 -0400 (AST) Received: from [192.168.0.4] (195-112-43-70.dyn.gotadsl.co.uk [195.112.43.70]) by smtp.nildram.co.uk (Postfix) with ESMTP id A105A26BFAD; Thu, 29 Dec 2005 14:55:29 +0000 (GMT) Subject: Re: Standby database & RAC concept in PostgresQL From: Simon Riggs To: Murugan G Cc: pgsql-admin@postgresql.org In-Reply-To: <038D31443AEF2040BC33D56D85DFD49A011AE588@sobha_mail.renaissance-it.com> References: <038D31443AEF2040BC33D56D85DFD49A011AE588@sobha_mail.renaissance-it.com> Content-Type: text/plain Date: Thu, 29 Dec 2005 14:55:31 +0000 Message-Id: <1135868131.2964.810.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.2.3 (2.2.3-2.fc4) Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.112 required=5 tests=[AWL=0.112] X-Spam-Score: 0.112 X-Spam-Level: X-Archive-Number: 200512/365 X-Sequence-Number: 20085 On Wed, 2005-12-28 at 13:29 +0530, Murugan G wrote: > Can I know whether Oracle's Standby database & RAC concepts available > in PostgresQL You can set up the equivalent of Oracle Standby if you wish, using PITR. Other methods of Replication for resilience are possible, such as Slony. pgcluster implements something similar to Oracle RAC, but I have not seen a production installation of this, though this may exist in Japan? pgpool can be used to load balance across multiple servers, if that was your requirement for RAC. Best Regards, Simon Riggs