Received: from makus.postgresql.org ([98.129.198.125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1T64jy-0007BD-LC for pgsql-admin@postgresql.org; Mon, 27 Aug 2012 19:12:50 +0000 Received: from mx2.d2.com ([66.251.81.121]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1T64jw-0001s8-3S for pgsql-admin@postgresql.org; Mon, 27 Aug 2012 19:12:49 +0000 Received: from mxb.d2.com ([10.85.4.6]) by mx2.d2.com (8.13.8/8.13.8) with ESMTP id q7RK8Mef018343 for ; Mon, 27 Aug 2012 13:08:37 -0700 X-ASG-Debug-ID: 1346094742-01d10a476d926560001-ysJW5H Received: from mail01.d2.com ([172.16.66.171]) by mxb.d2.com with ESMTP id SKIWjfzUmnmk0WwM for ; Mon, 27 Aug 2012 12:12:22 -0700 (PDT) X-Barracuda-Envelope-From: aalvarez@d2.com Received: from exbew2k3-02.d2.com (exbew2k3-02 [10.78.2.16]) by mail01.d2.com (8.13.8/8.13.8/Debian-3) with ESMTP id q7RJCMIP001054 for ; Mon, 27 Aug 2012 12:12:22 -0700 Received: from [10.126.2.222] ([10.126.2.222] RDNS failed) by exbew2k3-02.d2.com with Microsoft SMTPSVC(6.0.3790.3959); Mon, 27 Aug 2012 12:12:22 -0700 Message-ID: <503BC696.2080706@d2.com> Date: Mon, 27 Aug 2012 12:12:22 -0700 From: Amador Alvarez User-Agent: Mozilla/5.0 (X11; U; Linux i686 (x86_64); en-US; rv:1.9.2.27) Gecko/20120216 Lightning/1.0b2 Thunderbird/3.1.19 MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Looking for a better approach for pacemaker, DRDB VS pgsql 9.1 standby feature. Content-Type: text/plain; charset=ISO-8859-1; format=flowed X-ASG-Orig-Subj: Looking for a better approach for pacemaker, DRDB VS pgsql 9.1 standby feature. Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 27 Aug 2012 19:12:22.0610 (UTC) FILETIME=[E2EAC320:01CD8487] X-Barracuda-Connect: UNKNOWN[172.16.66.171] X-Barracuda-Start-Time: 1346094742 X-Barracuda-URL: http://10.85.4.6:8000/cgi-mod/mark.cgi X-Virus-Scanned: by bsmtpd at d2.com X-Barracuda-Spam-Score: 0.00 X-Barracuda-Spam-Status: No, SCORE=0.00 using per-user scores of TAG_LEVEL=1000.0 QUARANTINE_LEVEL=1000.0 KILL_LEVEL=9.0 tests= X-Barracuda-Spam-Report: Code version 3.2, rules version 3.2.2.106841 Rule breakdown below pts rule name description ---- ---------------------- -------------------------------------------------- X-Spam-Status: NO, score=-2.4 required=3.0 tests=ALL_TRUSTED,AWL,BAYES_00, RATWARE_GECKO_BUILD autolearn=ham version=3.2.4 X-Spam-Checker-Version: SpamAssassin 3.2.4 (2008-01-01) on mx2.d2.com X-Pg-Spam-Score: -0.7 (/) X-Archive-Number: 201208/113 X-Sequence-Number: 39934 Hi there, I am setting up a 2 node database cluster (Master/standby) on pgsql 9.1 and it looks to me that drdb option could be easier to maintain & keep running after several failovers on a row, specially because after a failover operation it is not too friendly to set back up automatically the former primary as the new standby. Besides I would not like to automate an rsync over the same data directory as it could be destroyed by a 'wrong' syncing . Any comments are welcome ! Thanks in advance, A.A.