Re: Upgrading from 8.4 and 9.0 to 9.1

On Mon, 2012-05-07 at 15:37 -0400, Scott Briggs wrote:
> On Mon, May 7, 2012 at 3:28 PM, Guillaume Lelarge
> <guillaume(at)lelarge(dot)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