| From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
|---|---|
| To: | Scott Briggs <scott(dot)br(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Upgrading from 8.4 and 9.0 to 9.1 |
| Date: | 2012-05-07 19:28:34 |
| Message-ID: | 1336418914.2320.49.camel@localhost.localdomain |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Briggs | 2012-05-07 19:37:50 | Re: Upgrading from 8.4 and 9.0 to 9.1 |
| Previous Message | Magnus Hagander | 2012-05-07 19:27:28 | Re: errors on restoring postgresql binary dump to glusterfs |