I'm getting ready to tackle another upgrade: 7.4.6 -> 8.3.3. The
preliminaries (development/testing) look good but I'd like
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?
2. Alter encoding from C to utf8.
pgsql-admin by date
|Next:||From: Joshua D. Drake||Date: 2008-06-18 17:28:33|
|Subject: Re: Major upgrade advice|
|Previous:||From: hubert depesz lubaczewski||Date: 2008-06-18 17:11:18|
|Subject: Re: URGENT: how to GRANT privillages to user/role onrelation's row??|