Re: How to update from 8.1 to 8.2 ? - Mailing list pgsql-admin

From Chris Hoover
Subject Re: How to update from 8.1 to 8.2 ?
Date
Msg-id 1d219a6f0709201106n24c000a7p9006f5b7257f2d69@mail.gmail.com
Whole thread Raw
In response to Re: How to update from 8.1 to 8.2 ?  (Carol Walter <walterc@indiana.edu>)
Responses Re: How to update from 8.1 to 8.2 ?  (Carol Walter <walterc@indiana.edu>)
List pgsql-admin


On 9/20/07, Carol Walter <walterc@indiana.edu> wrote:
We just did this.  I did a pg_dumpall using 8.1.  Then we fired up
8.2 while 8.1 was still running.  Uploaded the data to 8.2.  Then
shut 8.1 down.  This allowed us to have the database unavailable for
a very short time.

Carol


Carol,

If this is truely what you did, you are a very lucky person.  You are always supposed to dump the old database using the new versions pg_dump/pg_dumpall.  That way, pg_dump/pg_dumpall can set up the data for any changes made by the newer version.

Just an fyi for those following this thread.

HTH,

chris


pgsql-admin by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: Schedules Running Problem
Next
From: "Chris Hoover"
Date:
Subject: Re: Moving database install to new SAN