pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: delongboy <sdelong@saucontech.com>
To: pgsql-performance@postgresql.org
Subject: Re: How to upgrade from 9.1 to 9.2 with replication?
Date: Thu, 25 Oct 2012 07:12:04 -0700 (PDT)
Message-ID: <1351174324740-5729618.post@n5.nabble.com> (raw)
In-Reply-To: <CAGTBQpa_ZFEyzFGE_8+diVjUOiYMFARkUrPs2reBq71GaJ-tvg@mail.gmail.com>
References: <1350598882643-5728941.post@n5.nabble.com>
	<50816749.6010804@denninger.net>
	<CAGTBQpa_ZFEyzFGE_8+diVjUOiYMFARkUrPs2reBq71GaJ-tvg@mail.gmail.com>

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-tp5728941p57...
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.




view thread (21+ messages)  latest in thread

Message-ID: <1351174324740-5729618.post@n5.nabble.com>
Permalink:  ../1351174324740-5729618.post@n5.nabble.com/
Also on:    postgresql.org/message-id/1351174324740-5729618.post@n5.nabble.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: sdelong@saucontech.com
  Subject: Re: How to upgrade from 9.1 to 9.2 with replication?
  In-Reply-To: <1351174324740-5729618.post@n5.nabble.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox