Re: Upgrading from 8.4 and 9.0 to 9.1

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