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 по дате отправления: