From: | alexander lunyov <lan(at)zato(dot)ru> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: migrate data 6.5.3 -> 8.3.1 |
Date: | 2008-08-15 11:26:52 |
Message-ID: | 48A567FC.5090002@zato.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Guillaume Smet wrote:
> On Fri, Aug 15, 2008 at 11:42 AM, alexander lunyov <lan(at)zato(dot)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(at)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
From | Date | Subject | |
---|---|---|---|
Next Message | Tino Wildenhain | 2008-08-15 11:46:20 | Re: XML / XSL rendering in PostgreSQL server? |
Previous Message | Martin Pihlak | 2008-08-15 11:13:59 | Re: Patch: plan invalidation vs stored procedures |