Upgrading from 8.4 and 9.0 to 9.1

From: Scott Briggs <scott(dot)br(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Upgrading from 8.4 and 9.0 to 9.1
Date: 2012-05-07 19:10:59
Message-ID: CADKfymGd+xgMR8VO60Rk1aUB=caP5iHjj=0zjFc3zLg4FeOMVg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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? If
not, what's the best way to upgrade a production database to 9.1 with
no 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?

Thanks,
Scott

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Brent Wood 2012-05-07 19:26:22 Re: COPY column order
Previous Message Liang Ma 2012-05-07 17:34:18 Re: errors on restoring postgresql binary dump to glusterfs