Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TWCiZ-00066Q-Px for pgsql-performance@postgresql.org; Wed, 07 Nov 2012 20:59:23 +0000 Received: from momjian.us ([72.94.173.45]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TWCiX-0006UD-FQ for pgsql-performance@postgresql.org; Wed, 07 Nov 2012 20:59:23 +0000 Received: from bruce by momjian.us with local (Exim 4.72) (envelope-from ) id 1TWCiU-0004Zx-TI; Wed, 07 Nov 2012 15:59:18 -0500 Date: Wed, 7 Nov 2012 15:59:18 -0500 From: Bruce Momjian To: Claudio Freire Cc: Karl Denninger , delongboy , postgres performance list Subject: Re: How to upgrade from 9.1 to 9.2 with replication? Message-ID: <20121107205918.GD26215@momjian.us> References: <1350598882643-5728941.post@n5.nabble.com> <50816749.6010804@denninger.net> <20121107183633.GA19163@momjian.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.20 (2009-06-14) X-Pg-Spam-Score: -2.3 (--) X-Archive-Number: 201211/98 X-Sequence-Number: 48464 On Wed, Nov 7, 2012 at 03:44:13PM -0300, Claudio Freire wrote: > On Wed, Nov 7, 2012 at 3:36 PM, Bruce Momjian wrote: > >> Bring both down. > >> pg_upgrade master > >> Bring master up > >> pg_upgrade slave > > > > Is there any reason to upgrade the slave when you are going to do rsync > > anyway? Of course you need to install the new binaries and libs, but it > > seems running pg_upgrade on the standby is unnecessary. > > Just to speed up the rsync pg_upgrade is mostly modifying the system tables --- not sure if that is faster than just having rsync copy those. The file modification times would be different after pg_upgrade, so rsync might copy the file anyway when you run pg_upgrade. It would be good for you to test if it really is a win --- I would be surprised if pg_upgrade was in this case on the standby. -- Bruce Momjian http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. +