From: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
---|---|
To: | mailinglist(at)tdeo(dot)fr |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Migrate from mysql |
Date: | 2013-09-09 23:30:31 |
Message-ID: | 522E5A17.5080907@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 09/09/2013 03:15 PM, Florent THOMAS wrote:
> Hy folks,
>
> I'm trying to migrate a database running on mysql for the famous
> www.redmine.org from mysql to postgresql.
> I was looking for ressources and I found this :
> http://www.olimpiks.ru/2011/03/redmine-mysqlpostgresql-converter.html
> The process is almost perfect except for the binary datas.
What version of Postgres?
> I have this kind of messages :
>
> /psql:redmine_postgres.sql:155714: ERROR: invalid input syntax for type
> bytea
> LIGNE 1 : ...TO "wiki_content_versions" VALUES (561,108,108,24,E'h1. Proc...
> ^
> psql:redmine_postgres.sql:155728: ERROR: invalid input syntax for type bytea
> LIGNE 1 : ...TO "wiki_content_versions" VALUES (575,113,113,24,E'h1. Open...
The escape format for bytea changed, see here for more information:
http://www.postgresql.org/docs/9.3/interactive/datatype-binary.html
> /
> And other like this :
> /psql:redmine_postgres.sql:156648: ERROR: invalid byte sequence for
> encoding "UTF8": 0xda 0x75
> psql:redmine_postgres.sql:156649: ERROR: invalid byte sequence for
> encoding "UTF8": 0xda 0xcb
> psql:redmine_postgres.sql:156650: ERROR: invalid byte sequence for
> encoding "UTF8": 0xda 0x2d
> psql:redmine_postgres.sql:156651: ERROR: invalid byte sequence for
> encoding "UTF8": 0xef 0x6e 0xdb
> /
Encoding mismatch. What is the encoding for your source data?
> Does anyone already manage some migration and have some kind of issue on
> bytearray?
>
> Thanks for helping,
>
> regards
--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | John R Pierce | 2013-09-09 23:53:03 | Re: help getting a backtrace from 9.2 on Ubuntu 13.04? |
Previous Message | Merlin Moncure | 2013-09-09 23:06:36 | Re: Migrate from mysql |