| From: | Jeff Davis <jdavis-pgsql(at)empires(dot)org> |
|---|---|
| To: | schen(at)graciousstyle(dot)com |
| Cc: | PgSQL General List <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: postgresql 8.0 advantages |
| Date: | 2005-02-26 09:27:55 |
| Message-ID: | 1109410075.4089.216.camel@jeff |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs pgsql-general |
On Fri, 2005-02-25 at 09:20 -0800, Si Chen wrote:
> Thanks!
>
> Is there any documentation on how to upgrade to 8.0?
>
> 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
> directory/machine and then restore the database into it? Are there any
> incompatibilities/modifications to databases from the earlier veresion
> required?
>
You might want to check out Slony-I <http://www.slony.info> for the
purpose of upgrading. Slony is actually a replication engine, but it can
be used to upgrade with little or no downtime. Otherwise, just
dump/upgrade/restore like normal.
As far as compatibility, 8.0 should be mostly backwards compatible.
There may be some minor things that I don't know about, so I recommend
some testing first.
Regards,
Jeff Davis
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jim C. Nasby | 2005-02-26 21:35:27 | Re: postgresql 8.0 advantages |
| Previous Message | Si Chen | 2005-02-25 17:20:29 | Re: postgresql 8.0 advantages |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Benjamin | 2005-02-26 13:43:08 | Re: db replication and errors |
| Previous Message | Jeff Davis | 2005-02-26 08:35:30 | Re: row numbering |