Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 078021336971 for ; Tue, 22 Feb 2011 16:35:10 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 36848-05 for ; Tue, 22 Feb 2011 20:35:02 +0000 (UTC) X-Greylist: delayed 00:19:39.659516 by SQLgrey-1.7.6 Received: from sam.nabble.com (sam.nabble.com [216.139.236.26]) by mail.postgresql.org (Postfix) with ESMTP id 924521337B68 for ; Tue, 22 Feb 2011 16:35:02 -0400 (AST) Received: from [192.168.236.26] (helo=sam.nabble.com) by sam.nabble.com with esmtp (Exim 4.69) (envelope-from ) id 1Prydl-0001s5-F1 for pgsql-admin@postgresql.org; Tue, 22 Feb 2011 12:15:21 -0800 Date: Tue, 22 Feb 2011 12:15:21 -0800 (PST) From: Isabella Ghiurea To: pgsql-admin@postgresql.org Message-ID: <1298405721458-3396099.post@n5.nabble.com> In-Reply-To: References: Subject: Re: Heartbeat + pacemaker configuration for PostgreSQL log shipping MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.778 tagged_above=-10 required=5 tests=BAYES_00=-1.9, URI_HEX=1.122 X-Spam-Level: X-Archive-Number: 201102/192 X-Sequence-Number: 36831 Hi, we spend some time looking to use heartbeat Pg 9.0 and warm standby replication option to configure a "master/slave" system. At the end we have implemented DRBD and STONITH for a master Pg server, DRBD is been used for for all Pg db directories the only exception is the Pg software and backup directory, so far we like that the fail over procedure is very simple and time efficient , Pg is in consistency state always after a clean or "immediate/fast" shutdown ; the downside : this solution is protecting us only from hardware issues not software/Pg issues aka :Pg data, log files corruption. Hope this may help with your decision, Isabella -- View this message in context: http://postgresql.1045698.n5.nabble.com/Heartbeat-pacemaker-configuration-for-PostgreSQL-log-shipping-tp3394494p3396099.html Sent from the PostgreSQL - admin mailing list archive at Nabble.com.