Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

Next:From: Joshua D. DrakeDate: 2008-06-18 17:28:33
Subject: Re: Major upgrade advice
Previous:From: hubert depesz lubaczewskiDate: 2008-06-18 17:11:18
Subject: Re: URGENT: how to GRANT privillages to user/role onrelation's row??

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group