Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: How to update from 8.1 to 8.2 ?
- From: "Chris Hoover" <revoohc(at)gmail(dot)com>
- To: "Carol Walter" <walterc(at)indiana(dot)edu>
- Cc: "Milen A. Radev" <milen(at)radev(dot)net>, pgsql-admin(at)postgresql(dot)org
- Subject: Re: How to update from 8.1 to 8.2 ?
- Date: Thu, 20 Sep 2007 14:06:36 -0400
On 9/20/07, Carol Walter <walterc(at)indiana(dot)edu> wrote:
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
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
- Follow-Ups:
- Re: How to update from 8.1 to 8.2 ?
- From: Carol Walter
- Re: How to update from 8.1 to 8.2 ?
- References:
- How to update from 8.1 to 8.2 ?
- From: Josef Springer
- Re: How to update from 8.1 to 8.2 ?
- From: Milen A. Radev
- Re: How to update from 8.1 to 8.2 ?
- From: Carol Walter
- How to update from 8.1 to 8.2 ?
- Prev by Date: Re: Schedules Running Problem
- Next by Date: Re: Moving database install to new SAN
- Previous by thread: Re: How to update from 8.1 to 8.2 ?
- Next by thread: Re: How to update from 8.1 to 8.2 ?
- Indexes: