Major upgrade advice

Поиск
Список
Период
Сортировка
От Steve Crawford
Тема Major upgrade advice
Дата
Msg-id 48594429.7040001@pinpointresearch.com
обсуждение исходный текст
Ответы 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>)
Список 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 по дате отправления:

Предыдущее
От: "pradeep kumar"
Дата:
Сообщение: URGENT: how to GRANT privillages to user/role on relation's row??
Следующее
От: hubert depesz lubaczewski
Дата:
Сообщение: Re: URGENT: how to GRANT privillages to user/role on relation's row??