Major upgrade advice - Mailing list pgsql-admin

From Steve Crawford
Subject Major upgrade advice
Date
Msg-id 48594429.7040001@pinpointresearch.com
Whole thread Raw
Responses Re: Major upgrade advice  ("Joshua D. Drake" <jd@commandprompt.com>)
Re: Major upgrade advice  (Achilleas Mantzios <achill@matrix.gatewaynet.com>)
Re: Major upgrade advice  (Roberto Garcia <roberto.garcia@cptec.inpe.br>)
List pgsql-admin
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?

2. Alter encoding from C to utf8.

Cheers,
Steve



pgsql-admin by date:

Previous
From: "pradeep kumar"
Date:
Subject: URGENT: how to GRANT privillages to user/role on relation's row??
Next
From: hubert depesz lubaczewski
Date:
Subject: Re: URGENT: how to GRANT privillages to user/role on relation's row??