Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id A342E1337B61 for ; Mon, 1 Nov 2010 16:53:43 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 25864-10 for ; Mon, 1 Nov 2010 19:53:36 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from abpni.co.uk (unknown [92.27.106.173]) by mail.postgresql.org (Postfix) with ESMTP id 20BF21337B47 for ; Mon, 1 Nov 2010 16:53:35 -0300 (ADT) Received: from [10.87.0.130] ([10.87.0.130]) by abpni.co.uk with Microsoft SMTPSVC(6.0.3790.3959); Mon, 1 Nov 2010 19:53:34 +0000 Message-ID: <4CCF1AC4.6060800@abpni.co.uk> Date: Mon, 01 Nov 2010 19:53:40 +0000 From: Jonathan Tripathy User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.2.12) Gecko/20101027 Thunderbird/3.1.6 MIME-Version: 1.0 To: pgsql-general@postgresql.org Subject: Replication Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 01 Nov 2010 19:53:34.0817 (UTC) FILETIME=[77C3DD10:01CB79FE] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=3.212 tagged_above=-5 required=5 tests=BAYES_00=-1.9, FS_REPLICA=3.599, RDNS_NONE=0.793, SARE_SPEC_REPLICA=0.72 X-Spam-Level: *** X-Archive-Number: 201011/64 X-Sequence-Number: 169130 Hi Everyone, I'm looking for the best solution for "Hot Standbys" where once the primary server fails, the standby will take over and act just like the master did. The standby must support INSERTS and UPDATES as well (once the master has failed) Are there any solutions like this? Looking on the Postgresql site, all the standby solutions seem to be read only.. Thanks