Friday, August 15, 2008

Re: [HACKERS] migrate data 6.5.3 -> 8.3.1

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

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

No comments: