Migration using pg_restore

Поиск
Список
Период
Сортировка
От Jan Cruz
Тема Migration using pg_restore
Дата
Msg-id 493da2780602172359p3fa963b3xb1b4e8f77e97758@mail.gmail.com
обсуждение исходный текст
Список pgsql-general
Note:
  Assumption tables are already created and/or in existence.

I dump all data from a 7.3.5 db using LATIN9 encoding.
When I restore it back to a 8.1.3 db using LATIN9 encoding
it is much slower than restoring back to a 7.3.xx db.
Restoration from 7.3.5 to 8.1.3 took more or less 24 hours against
less than an hour  from 7.3.5 db to any 7.3.xx db.

I don't have any idea why is it that way...

Anyone?

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

Предыдущее
От: Rick Gigger
Дата:
Сообщение: Re: Converting an ASCII database to an UTF-8 database
Следующее
От: "Jan Cruz"
Дата:
Сообщение: Re: Converting an ASCII database to an UTF-8 database