Re: Upgrading 6.5.1

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Upgrading 6.5.1
Дата
Msg-id 3872.1040101188@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Upgrading 6.5.1  (Jean-Christian Imbeault <jc@mega-bucks.co.jp>)
Список pgsql-general
Jean-Christian Imbeault <jc@mega-bucks.co.jp> writes:
> 6.5.1 is *really* old. Are there any docs still left lying around on
> things I should watch out for (data types that are no longer supported
> for example) when moving the data?

You should probably expect problems ... for example, the standard names
of datetime-related datatypes are different now.

I would suggest dumping schema and data separately (pg_dump -s and -a
IIRC).  Try to load the schema, edit manually, repeat till successful.
Then try to load the data.  With luck you won't need any data edits.

            regards, tom lane

В списке pgsql-general по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Upgrading 6.5.1
Следующее
От: Lincoln Yeoh
Дата:
Сообщение: Re: Upgrading 6.5.1