upgrade requires dump/restore?
От | charette@writeme.com (Stephane Charette) |
---|---|
Тема | upgrade requires dump/restore? |
Дата | |
Msg-id | 1be4bb40.0302101407.db6aac1@posting.google.com обсуждение исходный текст |
Ответы |
Re: upgrade requires dump/restore?
|
Список | pgsql-admin |
While reading FAQ at http://www.ca.postgresql.org/docs/faq-english.html#3.10, the following advice is given: "The PostgreSQL team makes only small changes between minor releases, so upgrading from 7.2 to 7.2.1 does not require a dump and restore. However, major releases (e.g. from 7.2 to 7.3) often change the internal format of system tables and data files." Our question is, how do we determine if we need a dump/restore or not? We have several hundred boxes that are currently running 7.2, and we're in the process of putting together a new software update that will (among other things) upgrade the database to 7.2.3. Is a dump/restore required from 7.2 to 7.2.3? What if we were to go from 7.2 to 7.2.4, or even from 7.2 to the latest, 7.3.2? How can we tell when a dump/restore is required? Thanks, Stephane Charette stephanecharette <nospam> at telus <nospam> dot net
В списке pgsql-admin по дате отправления: