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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
