Re: Upgrading from 8.4 and 9.0 to 9.1 - Mailing list pgsql-general

From Guillaume Lelarge
Subject Re: Upgrading from 8.4 and 9.0 to 9.1
Date
Msg-id 1336420798.2320.54.camel@localhost.localdomain
Whole thread Raw
In response to Re: Upgrading from 8.4 and 9.0 to 9.1  (Scott Briggs <scott.br@gmail.com>)
List pgsql-general
On Mon, 2012-05-07 at 15:37 -0400, Scott Briggs wrote:
> On Mon, May 7, 2012 at 3:28 PM, Guillaume Lelarge
> <guillaume@lelarge.info> wrote:
> > On Mon, 2012-05-07 at 15:10 -0400, Scott Briggs wrote:
> >> Hi, so I have a master-slave set of database servers that are running
> >> postgres 9.0 using streaming replication and I'd like to migrate them
> >> to 9.1.  My question is, can 9.0 do streaming replication to 9.1?
> >
> > No.
> >
> >>   If
> >> not, what's the best way to upgrade a production database to 9.1 with
> >> no downtime?
> >>
> >
> > No downtime? you'll obviously have downtime to get the new binaries.
> > Anyway, you should try pg_upgrade to have less downtime.
>
> Let me clarify, no downtime meaning I will be failing over from the
> current server running 9.0 to a new server running 9.1.

pg_upgrade or Slony as Raymond already told you. pg_upgrade is newer but
easier, Slony is older, probably with less bugs, but hardier. Your
choice :)

> >> I also have a number of 8.4 servers that I'd like to upgrade to 9.1,
> >> can 8.4 ship WAL files to 9.1?
> >>
> >
> > Nope. Streaming replication doesn't work between major versions.
>
> Since 8.4 doesn't do streaming replication,

Sure.

>  I'm asking about shipping
> WAL files via the archive command using rsync.  This is our current
> replication setup for most of our older postgres servers.

Let me rephrase it... log shipping and streaming replication don't work
between major versions.


--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com


pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Simultaneous Installations 7.4 9.x
Next
From: Igor
Date:
Subject: Use LISTEN/NOTIFY between different databases