Re: migrate data 6.5.3 -> 8.3.1

Поиск
Список
Период
Сортировка
От alexander lunyov
Тема Re: migrate data 6.5.3 -> 8.3.1
Дата
Msg-id 48A567FC.5090002@zato.ru
обсуждение исходный текст
Ответ на Re: migrate data 6.5.3 -> 8.3.1  ("Guillaume Smet" <guillaume.smet@gmail.com>)
Список pgsql-hackers
Guillaume Smet wrote:
> On Fri, Aug 15, 2008 at 11:42 AM, alexander lunyov <lan@zato.ru> wrote:
>> i didn't find anything like postgresql.conf on old server. Right now i'm
>> tried to start 6.5.3 on windows (downloaded binary from ftp archive on
>> postgresql.org, installed last cygwin) with the data dir from old server,
>> but there's errors:
> 
> Add the -i option to your startup command line. You should then be
> able to connect using the network.

Thanks a lot! It did a trick, so now i can connect to it. I followed 
your advice and installed 7.3 client and tried to dump and get this error:

JAIL@incubator@root # pg_dump -U ira -h 192.168.0.3 itt_user
pg_dump: [archiver (db)] connection to database "itt_user" failed: 
ERROR:  MultiByte strings (MB) must be enabled to use this function

I searched for meaning of this error, and found solution here:

http://archives.postgresql.org/pgsql-general/2000-09/msg00489.php

"Recompile your 7.0.2 without --enable-multibyte option."

but in 7.3 configure no such option.

-- 
alexander lunyov


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

Предыдущее
От: Martin Pihlak
Дата:
Сообщение: Re: Patch: plan invalidation vs stored procedures
Следующее
От: Tino Wildenhain
Дата:
Сообщение: Re: XML / XSL rendering in PostgreSQL server?