[rt-users] 3.4.2 to 4.x

[Jeff Blaine]

The RT 3.4 to RT 4.0.4 upgrade went fine.

Now with our data in MySQL 5.1.x, instead of the old
MySQL 4.1, and our new instance not in production yet,
we want to migrate to PostgreSQL 8.4.9, largely in
order to get performant full-text searching without
doing something hackish with MySQL and Sphinx nonsense.

That task, however, is turning out to be a nightmare.
The gory details are at the link below, but the short
story is that PostgreSQL does not like some of the
bytes (mostly when trying to INSERT into Attachments).

Cleaning the dump file of all non-ASCII characters,
then trying the data load again, bought me nothing (!!??).

http://dba.stackexchange.com/questions/9792/no-nulls-yet-invalid-byte-sequence-for-encoding-utf8-0x00

If anyone has any advice, please share!