| From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
|---|---|
| To: | Steve Crawford <scrawford(at)pinpointresearch(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Major upgrade advice |
| Date: | 2008-06-18 17:28:33 |
| Message-ID: | 1213810113.8601.197.camel@jd-laptop |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Wed, 2008-06-18 at 10:21 -0700, Steve Crawford wrote:
> I'm getting ready to tackle another upgrade: 7.4.6 -> 8.3.3. The
> preliminaries (development/testing) look good but I'd like
> suggestions/warnings/comments on:
>
> 1. Removing OIDs on user tables.
>
> I don't see any dump or restore options to remove OIDs. Am I better off
> modifying the dump to alter the "SET default_with_oids = true;" lines or
> going through all the user tables in advance and running "ALTER TABLE
> ... SET WITHOUT OIDS"? Other options?
If the table has oids, pg_dump is going to grab them and restore them as
such. If you are assured that you don't need OIDs I would drop the oid
columns from the user tables before the upgrade.
>
> 2. Alter encoding from C to utf8.
Very good chance the dump will not load without going through a cleanup
with iconv.
Joshua D. Drake
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Achilleas Mantzios | 2008-06-18 18:00:29 | Re: Major upgrade advice |
| Previous Message | Steve Crawford | 2008-06-18 17:21:45 | Major upgrade advice |