Re: Is any 'upgrade' required to move a 9.0.1 cluster to 9.0.2? - Mailing list pgsql-admin

From Kevin Grittner
Subject Re: Is any 'upgrade' required to move a 9.0.1 cluster to 9.0.2?
Date
Msg-id 4D0F30030200002500038828@gw.wicourts.gov
Whole thread Raw
In response to Is any 'upgrade' required to move a 9.0.1 cluster to 9.0.2?  (Lou Picciano <loupicciano@comcast.net>)
List pgsql-admin
Lou Picciano <loupicciano@comcast.net> wrote:

> Is any 'upgrade' required to move a 9.0.1 cluster to 9.0.2?

The "general rule" on this is here:

http://www.postgresql.org/support/versioning

To quote from that page:

| Upgrading to a minor release does not require a dump and restore;
| merely stop the database server, install the updated binaries, and
| restart the server. For some releases, manual changes may be
| required to complete the upgrade, so always read the release notes
| before upgrading.

The release notes for the most recent minor release for each
supported major release is available from the main PostgreSQL page:

http://www.postgresql.org/

In this case, the release notes page is:

http://www.postgresql.org/docs/9.0/static/release-9-0-2.html

which says:

| E.1.1. Migration to Version 9.0.2
|
| A dump/restore is not required for those running 9.0.X.

-Kevin

pgsql-admin by date:

Previous
From: Benoit Clennett-Sirois
Date:
Subject: Re: Postgres crash during low-traffic period, need advice.
Next
From: Iñigo Martinez Lasala
Date:
Subject: Data duplication when moving datafiles from one server to another.