Re: 8.5 beta manual - Mailing list pgsql-novice

From Thom Brown
Subject Re: 8.5 beta manual
Date
Msg-id bddc86151001241242w2b060099t153cf6895ae983d3@mail.gmail.com
Whole thread Raw
In response to Re: 8.5 beta manual  (Mladen Gogala <mladen.gogala@vmsinfo.com>)
List pgsql-novice
2010/1/24 Mladen Gogala <mladen.gogala@vmsinfo.com>
Will there be an upgrade procedure, too? There is a growing problem with PgSQL not allowing upgrades and requesting that the databases should be rebuilt from scratch, using pg_dumpall. My company is planning to create a Postgres database 1TB in size, but the upgrades are a major obstacle in the planning.



No doubt pg-migrator will enable fast upgrades between versions, but you aren't required to upgrade to the latest major version.  For example, if you're on 8.4.2, and loads of security patches and bug fixes are released as 8.4.3, there won't be any breaking changes, so you can upgrade to that minor version and no dump and restore is required.

Regards

Thom

pgsql-novice by date:

Previous
From: Mladen Gogala
Date:
Subject: Re: 8.5 beta manual
Next
From: Pushpendra Singh Thakur
Date:
Subject: Re: optional reference