Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YdMdo-0005jC-KR for pgsql-admin@arkaria.postgresql.org; Wed, 01 Apr 2015 17:41:24 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1YdMdo-0001rG-3m for pgsql-admin@arkaria.postgresql.org; Wed, 01 Apr 2015 17:41:24 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1YdMdn-0001rA-94 for pgsql-admin@postgresql.org; Wed, 01 Apr 2015 17:41:23 +0000 Received: from imx3.etecsa.cu ([200.55.152.137]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YdMdj-0003oc-5O for pgsql-admin@postgresql.org; Wed, 01 Apr 2015 17:41:21 +0000 Received: from Unknown ([192.168.91.42] helo=mn2.etecsa.cu) by imx3.etecsa.cu with ESMTP id tCeEuC6t80195; Wed, 1 Apr 2015 12:40:14 -0500 Received: (qmail 711 invoked by uid 11185); 1 Apr 2015 18:40:57 -0000 Received: from 192.168.91.6 by mn2.etecsa.cu (envelope-from , uid 502) with qmail-scanner-2.08 (spamassassin: 3.2.5. Clear:RC:1(192.168.91.6):. Processed in 0.051196 secs); 01 Apr 2015 18:40:57 -0000 Received: from unknown (HELO webmail.etecsa.cu) ([192.168.91.6]) (envelope-sender ) by mn2.etecsa.cu (qmail-ldap-1.03) with SMTP for ; 1 Apr 2015 18:40:56 -0000 Received: from 192.168.207.54 (SquirrelMail authenticated user gilberto.castillo) by webmail.etecsa.cu with HTTP; Wed, 1 Apr 2015 13:40:56 -0500 (GMT+5) Message-ID: <38093.192.168.207.54.1427913656.squirrel@webmail.etecsa.cu> In-Reply-To: <551C2B89.3030106@evaristesys.com> References: <551C295D.6060602@evaristesys.com> <38078.192.168.207.54.1427912995.squirrel@webmail.etecsa.cu> <551C2B89.3030106@evaristesys.com> Date: Wed, 1 Apr 2015 13:40:56 -0500 (GMT+5) Subject: Re: Restoring normal master-slave roles after replication failure From: "Gilberto Castillo" To: "Alex Balashov" Cc: gilberto.castillo@etecsa.cu, pgsql-admin@postgresql.org Reply-To: gilberto.castillo@etecsa.cu User-Agent: SquirrelMail/1.4.8-5.el5_4.10 MIME-Version: 1.0 X-Priority: 3 (Normal) Importance: Normal X-SpamTest-Envelope-From: gilberto.castillo@etecsa.cu X-SpamTest-Info: Profiles 72422 [Jan 28 2015] X-SpamTest-Method: none X-SpamTest-Rate: 0 X-SpamTest-Status: Not detected X-SpamTest-Status-Extended: not_detected X-SpamTest-Version: SMTP-Filter Version 3.0.0 [0285], KAS30/SDK/Release X-Anti-Virus: Kaspersky Mail Gateway, version: 5.6.28/RELEASE, bases: 20140401T050822 #7726142, check: 20150401 clean Content-Type: multipart/mixed; boundary="=tCeFuK3i14076=imx3.etecsa.cu=" X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org This is a multi-part message in MIME format. --=tCeFuK3i14076=imx3.etecsa.cu= Content-Disposition: inline Content-Type: text/plain;charset=utf-8 Content-Transfer-Encoding: 8bit > > Hi Gilberto, > > On 04/01/2015 02:29 PM, Gilberto Castillo wrote: > >> Have you seen pgpool or rpmgr-3? > > I have, but prefer not to use these tools if possible as it would > complicate the setup. > > I'm not so much looking for front-end simplicity as I am looking for a > way to avoid having to do a base backup back to the master. I am fine > with having to reconfigure master and slave roles manually. I commented, and I used pgpool ensures failover a transparent manner to end users. Now use rpmgr-3, which allows me the same; but without the complicated motaje of pgpool. But if you want to do manuel, you define archive_command = "hot_stanby" on both nodes Saludos, Gilberto Castillo ETECSA, La Habana, Cuba --=tCeFuK3i14076=imx3.etecsa.cu= Content-Type: text/plain Content-Disposition: inline --- This message was processed by Kaspersky Mail Gateway 5.6.28/RELEASE running at host imx3.etecsa.cu Visit our web-site: , --=tCeFuK3i14076=imx3.etecsa.cu= Content-Type: text/plain Content-Disposition: inline Content-Transfer-Encoding: 8bit MIME-Version: 1.0 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin --=tCeFuK3i14076=imx3.etecsa.cu=--