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 1336418914.2320.49.camel@localhost.localdomain
Whole thread Raw
In response to Upgrading from 8.4 and 9.0 to 9.1  (Scott Briggs <scott.br@gmail.com>)
Responses Re: Upgrading from 8.4 and 9.0 to 9.1
List pgsql-general
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.

> 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.


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


pgsql-general by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: errors on restoring postgresql binary dump to glusterfs
Next
From: Scott Briggs
Date:
Subject: Re: Upgrading from 8.4 and 9.0 to 9.1