Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WPuEc-0005vl-0R for pgsql-admin@arkaria.postgresql.org; Tue, 18 Mar 2014 13:39:14 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1WPuEb-0006aL-GT for pgsql-admin@arkaria.postgresql.org; Tue, 18 Mar 2014 13:39:13 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WPuEa-0006aF-Jk for pgsql-admin@postgresql.org; Tue, 18 Mar 2014 13:39:12 +0000 Received: from imx3.etecsa.cu ([200.55.152.137]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WPuEX-0002L9-SG for pgsql-admin@postgresql.org; Tue, 18 Mar 2014 13:39:12 +0000 Received: from Unknown ([192.168.91.42] helo=mn2.etecsa.cu) by imx3.etecsa.cu with ESMTP id s9c6HG6g61891; Tue, 18 Mar 2014 09:38:06 -0500 Received: (qmail 3879 invoked by uid 11185); 18 Mar 2014 14:38:11 -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.019555 secs); 18 Mar 2014 14:38:11 -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 ; 18 Mar 2014 14:38:11 -0000 Received: from 192.168.207.54 (SquirrelMail authenticated user gilberto.castillo) by webmail.etecsa.cu with HTTP; Tue, 18 Mar 2014 09:38:06 -0500 (GMT+5) Message-ID: <37084.192.168.207.54.1395153486.squirrel@webmail.etecsa.cu> In-Reply-To: <1395149140.23656.YahooMailNeo@web133203.mail.ir2.yahoo.com> References: <1395149140.23656.YahooMailNeo@web133203.mail.ir2.yahoo.com> Date: Tue, 18 Mar 2014 09:38:06 -0500 (GMT+5) Subject: Re: pg_upgrade in primary/standby architecture From: "Gilberto Castillo" To: "Glyn Astill" Cc: "Murthy Nunna" , "Venkata Balaji Nagothi" , "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 58410 [Mar 18 2014] 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: 20140318T014408 #7538934, check: 20140318 clean Content-Type: multipart/mixed; boundary="=s9c8HWHt83143=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. --=s9c8HWHt83143=imx3.etecsa.cu= Content-Disposition: inline Content-Type: text/plain;charset=utf-8 Content-Transfer-Encoding: 8bit > > > >> From: Murthy Nunna >>To: Venkata Balaji Nagothi >>Cc: "pgsql-admin@postgresql.org" >>Sent: Tuesday, 18 March 2014, 12:49 >>Subject: Re: [ADMIN] pg_upgrade in primary/standby architecture >> >> >> >>Hi Venkata Balaji, >>  >>Thank you! >>  >>Yes, streaming replication cannot be setup between two different >> versions. That is true. >>  >>I am looking to upgrade both primary and standby with minimal outage to >> application….. I want to know if it is possible. If it is not possible, >> is there any architecture where we can minimize upgrade related outage? >>  > > You could use Slony-I for this, and it should be fairly quick to set up > now that as of 2.2 you can add multiple tables and sequences in one go > with SET ADD TABLE. I have a small guide that can be useful. Saludos, Gilberto Castillo La Habana, Cuba --=s9c8HWHt83143=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: , --=s9c8HWHt83143=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 --=s9c8HWHt83143=imx3.etecsa.cu=--