Обсуждение: Is any 'upgrade' required to move a 9.0.1 cluster to 9.0.2?

On Mon, Dec 20, 2010 at 8:06 AM, Lou Picciano <loupicciano@comcast.net> wrote:
> Gang,
> Is any 'upgrade' required to move a 9.0.1 cluster to 9.0.2?    TIA, Lou

No, just upgrade the binaries and bounce your cluster.

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