Re: migrate data 6.5.3 -> 8.3.1

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: migrate data 6.5.3 -> 8.3.1
Дата
Msg-id 20665.1218809691@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: migrate data 6.5.3 -> 8.3.1  (alexander lunyov <lan@zato.ru>)
Ответы Re: migrate data 6.5.3 -> 8.3.1  (alexander lunyov <lan@zato.ru>)
Re: migrate data 6.5.3 -> 8.3.1  (alexander lunyov <lan@zato.ru>)
Список pgsql-hackers
alexander lunyov <lan@zato.ru> writes:
> I want to try new pg_dump to connect to old server, but i can't - old
> postgres doesn't listening to network socket.

It won't work anyway: modern versions of pg_dump are only designed to
work with servers back to 7.0.  I see from the rest of the thread that
you tried to bludgeon it into submission, but I'd very strongly
recommend that you abandon that approach and use 6.5's pg_dump.

A further suggestion is that you use -d or even -D option on the dump.
I think there have been some corner-case changes in COPY data format
since 6.5 days; which might or might not bite you, but why take the
chance ...
        regards, tom lane


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: So what about XSLT?
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: So what about XSLT?