Re: postgresql 8.0 advantages

From: Lonni J Friedman <netllama(at)gmail(dot)com>
To: schen(at)graciousstyle(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: postgresql 8.0 advantages
Date: 2005-02-25 17:20:23
Message-ID: 7c1574a905022509204c85ce21@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs pgsql-general

On Fri, 25 Feb 2005 09:20:29 -0800, Si Chen <schen(at)graciousstyle(dot)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(at)gmail(dot)com
LlamaLand http://netllama.linux-sxs.org

In response to

Browse pgsql-docs by date

  From Date Subject
Next Message Si Chen 2005-02-25 17:20:29 Re: postgresql 8.0 advantages
Previous Message Tom Lane 2005-02-25 16:15:15 Re: postgresql 8.0 advantages

Browse pgsql-general by date

  From Date Subject
Next Message Si Chen 2005-02-25 17:20:29 Re: postgresql 8.0 advantages
Previous Message Tom Lane 2005-02-25 17:13:11 Re: Possible to run the server with ANSI/ISO string escapeing