Re: Major upgrade advice

Στις Wednesday 18 June 2008 20:21:45 ο/η Steve Crawford έγραψε:
> 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?

pg_dump by default ommits OIDs.
However why do you want to completely remove OID functionality?
space usage?

>
> 2. Alter encoding from C to utf8.

there is a script hanging around to do just that.
(i miss it at the moment)

>
> Cheers,
> Steve
>
>
>

--
Achilleas Mantzios