upgrade requires dump/restore?

From: charette(at)writeme(dot)com (Stephane Charette)
To: pgsql-admin(at)postgresql(dot)org
Subject: upgrade requires dump/restore?
Date: 2003-02-10 22:07:18
Message-ID: 1be4bb40.0302101407.db6aac1@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Yudha Setiawan 2003-02-11 06:57:46 Spread the schema
Previous Message Panchal, Ritesh 2003-02-10 20:03:41 Database backup