Received: from makus.postgresql.org ([98.129.198.125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TROAP-0007j2-BL for pgsql-performance@postgresql.org; Thu, 25 Oct 2012 14:12:13 +0000 Received: from sam.nabble.com ([216.139.236.26]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TROAK-0003dr-85 for pgsql-performance@postgresql.org; Thu, 25 Oct 2012 14:12:12 +0000 Received: from [192.168.236.26] (helo=sam.nabble.com) by sam.nabble.com with esmtp (Exim 4.72) (envelope-from ) id 1TROAG-0006Ej-OY for pgsql-performance@postgresql.org; Thu, 25 Oct 2012 07:12:04 -0700 Date: Thu, 25 Oct 2012 07:12:04 -0700 (PDT) From: delongboy To: pgsql-performance@postgresql.org Message-ID: <1351174324740-5729618.post@n5.nabble.com> In-Reply-To: References: <1350598882643-5728941.post@n5.nabble.com> <50816749.6010804@denninger.net> Subject: Re: How to upgrade from 9.1 to 9.2 with replication? MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -0.1 (/) X-Archive-Number: 201210/335 X-Sequence-Number: 48294 I brought down the master then the slave and upgraded both. Then I did the rsync and brought both up.. This worked. However with the database being very large it took quite a while. It seemed rsync had to make a lot of changes.. this surprised me. I thought they would be almost identical. But in the end it did work. just took longer than I had hoped. We will soon be tripling the size of our database as we move oracle data in.. so this process may not be so feasible next time. -- View this message in context: http://postgresql.1045698.n5.nabble.com/How-to-upgrade-from-9-1-to-9-2-with-replication-tp5728941p5729618.html Sent from the PostgreSQL - performance mailing list archive at Nabble.com.