Major upgrade advice

From: Steve Crawford <scrawford(at)pinpointresearch(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Major upgrade advice
Date: 2008-06-18 17:21:45
Message-ID: 48594429.7040001@pinpointresearch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Joshua D. Drake 2008-06-18 17:28:33 Re: Major upgrade advice
Previous Message hubert depesz lubaczewski 2008-06-18 17:11:18 Re: URGENT: how to GRANT privillages to user/role on relation's row??