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

Re: Major upgrade advice

From: Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Cc: Steve Crawford <scrawford(at)pinpointresearch(dot)com>
Subject: Re: Major upgrade advice
Date: 2008-06-18 18:00:29
Message-ID: 200806182100.30833.achill@matrix.gatewaynet.com (view raw or flat)
Thread:
Lists: pgsql-admin
Στις 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

In response to

Responses

pgsql-admin by date

Next:From: Steve CrawfordDate: 2008-06-18 18:24:15
Subject: Re: Major upgrade advice
Previous:From: Joshua D. DrakeDate: 2008-06-18 17:28:33
Subject: Re: Major upgrade advice

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