Re: postgresql 8.0 advantages - Mailing list pgsql-general

From Lonni J Friedman
Subject Re: postgresql 8.0 advantages
Date
Msg-id 7c1574a905022509204c85ce21@mail.gmail.com
Whole thread Raw
In response to Re: postgresql 8.0 advantages  (Si Chen <schen@graciousstyle.com>)
List pgsql-general
On Fri, 25 Feb 2005 09:20:29 -0800, Si Chen <schen@graciousstyle.com> wrote:
> Thanks!
>
> Is there any documentation on how to upgrade to 8.0?

Dump your DB, install 8.0, reload your DB.  Since you'e using RHEL3,
you should use the RPMs and it will be fairly easy.

> Is it possible to upgrade from 7.4 to 8.0 while keeping a production
> database running "in place"?  Or should I install 8.0 in another

No, its not.

> directory/machine and then restore the database into it?  Are there any
> incompatibilities/modifications to databases from the earlier veresion
> required?

Depends on what kind of data structures you have in the DB


--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
L. Friedman                                    netllama@gmail.com
LlamaLand                       http://netllama.linux-sxs.org

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Possible to run the server with ANSI/ISO string escapeing
Next
From: Charl Gerber
Date:
Subject: Install scripts?