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