| From: | "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
|---|---|
| To: | "quickinfo *EXTERN*" <quickinfo123(at)gmail(dot)com>, <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Migrating Postgresql 8.0 to 8.3 |
| Date: | 2012-08-13 13:09:35 |
| Message-ID: | D960CB61B694CF459DCFB4B0128514C208419F13@exadv11.host.magwien.gv.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
quickinfo wrote:
> I would like to migrate postgresql 8.0 to 8.3. Please suggest me the
best way of restoring my backup.
>
> In which format should I take the backup and how should I restore the
data. Does it require to write
> any sql script. will it create any problems in migrating 8.0 to 8.3.
Follow there directions:
http://www.postgresql.org/docs/8.3/static/install-upgrading.html
There is one behaviour change in 8.3 that caused problems for many
people:
http://www.postgresql.org/docs/8.3/static/release-8-3.html#AEN87860
Read the first point.
If that is a problem for you, read this:
http://petereisentraut.blogspot.co.at/2008/03/readding-implicit-casts-in
-postgresql.html
You should definitely upgrade to 9.1 and not to 8.3
Yours,
Laurenz Albe
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Craig Ringer | 2012-08-13 13:33:56 | Re: Migrating Postgresql 8.0 to 8.3 |
| Previous Message | quickinfo | 2012-08-13 12:40:28 | Migrating Postgresql 8.0 to 8.3 |