Re: migrate data 6.5.3 -> 8.3.1 - Mailing list pgsql-hackers

From alexander lunyov
Subject Re: migrate data 6.5.3 -> 8.3.1
Date
Msg-id 48A567FC.5090002@zato.ru
Whole thread Raw
In response to Re: migrate data 6.5.3 -> 8.3.1  ("Guillaume Smet" <guillaume.smet@gmail.com>)
List 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 by date:

Previous
From: Martin Pihlak
Date:
Subject: Re: Patch: plan invalidation vs stored procedures
Next
From: Tino Wildenhain
Date:
Subject: Re: XML / XSL rendering in PostgreSQL server?