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