pg.ddx.io pgsql-performance@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Postgres Upgrade from 8.4 to 9.1 2+ messages / 2 participants [nested] [flat]
* Postgres Upgrade from 8.4 to 9.1 @ 2012-08-06 05:38 Rajiv Kasera <rajiv.kasera@pinelabs.com> 0 siblings, 1 reply; 2+ messages in thread From: Rajiv Kasera @ 2012-08-06 05:38 UTC (permalink / raw) To: pgsql-performance Hi, I am planning a Postgres migration from 8.4 to 9.1 to be able to leverage the replication features available in the 9.1 version. I would like to understand the following things in this regard: 1. Any good documentation which should help in this upgrade. 2. To be able to replicate the complete steps in a test environment before doing it in LIVE which is running 9.0, is it possible to revert this database to 8.4 and then upgrade to 9.1. 3. Any known issues and changes required to be done in the application for this upgrade. Thanks, rajiv ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Postgres Upgrade from 8.4 to 9.1 @ 2012-08-08 06:50 Craig Ringer <ringerc@ringerc.id.au> parent: Rajiv Kasera <rajiv.kasera@pinelabs.com> 0 siblings, 0 replies; 2+ messages in thread From: Craig Ringer @ 2012-08-08 06:50 UTC (permalink / raw) To: rajiv.kasera@pinelabs.com; +Cc: pgsql-performance On 08/06/2012 01:38 PM, Rajiv Kasera wrote: > > Hi, > > I am planning a Postgres migration from 8.4 to 9.1 to be able to > leverage the replication features available in the 9.1 version. I > would like to understand the following things in this regard: > > 1.Any good documentation which should help in this upgrade. > The most important documentation here is the release notes for the major .0 versions: http://www.postgresql.org/docs/current/static/release-9-1.html <http://www.postgresql.org/docs/9.1/static/release-9-1.html; http://www.postgresql.org/docs/ <http://www.postgresql.org/docs/9.1/static/release-9-0.html>current <http://www.postgresql.org/docs/9.1/static/release-9-1.html>/static/release-9-0.html <http://www.postgresql.org/docs/9.1/static/release-9-0.html; ... in particular the "Migration to" sections. > 2.To be able to replicate the complete steps in a test environment > before doing it in LIVE which is running 9.0, is it possible to revert > this database to 8.4 and then upgrade to 9.1. > No. Take a copy before upgrading. Always. Keep the copy read-only in some safe place. If you want to revert, make a copy of your backup and use that. Upgrades from 8.4 to 9.0 or 9.1 require a dump and reload or the use of the pg_upgrade tool. You can't just install the new version and start it on your old database. > 3.Any known issues and changes required to be done in the application > for this upgrade. > See the release notes. -- Craig Ringer ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2012-08-08 06:50 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2012-08-06 05:38 Postgres Upgrade from 8.4 to 9.1 Rajiv Kasera <rajiv.kasera@pinelabs.com> 2012-08-08 06:50 ` Craig Ringer <ringerc@ringerc.id.au>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox