[rt-users] Mysql to Postgres Problems

[Gilmar Santos Jr]

Hello Mario,

I considered migrating a couple weeks ago. I wrote a tutorial[1] about
it and a Perl script to help with the process. I've just added a few
instructions at RT wiki.

We have almost 400.000 tickets and had serious performance problems. Pg
performed much worse than MySQL, even after performance tunning
configurations. After increasing innodb_buffer_poll_size (MySQL's
configuration directive) the performance problem was gone.

I tested with RT 3.4.5, but i think it will work fine on 3.6, since
there were no schema changes.

ps.: create database on postgre with encoding *latin1*.

Good luck,
Gilmar Santos Jr


Mario Gomide escreveu:
> Hello list!
>
> I used to use RT-3.4.1 on MySQL and I´m trying to migrate to RT-3.6.1
> on PostgreSQL 8.1.
> I´m having some problems with the database import process.
>
> I get the same errors many times:
> ERROR:  invalid byte sequence for encoding "UTF8":
> and
> invalid input syntax for integer: ""
> Can I just change the value to NULL where the value is empty?
>
> I have noticed that most of my data was imported...
>
> First of all I begin a new RT 3.6.1 installation, then I follow these
> instructions (http://wiki.bestpractical.com/index.cgi?MySQLToPg).
> That is: Dump from mysql is done:
> mysqldump -u user -p mydatabase > dumpfile.sql
> I edit this dumpfile leaving it only with INSERT INTO lines and
> removing everything related to the sessions table.
> Then on my new installation, I access the DB and DELETE FROM each table.
> After that, I do:
> psql -h localhost -f dumpfile.sql newdb
>
> After that I run the make upgrade process.
>
> I hope you can help me out.
> Thanks
>
> Mario Gomide
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> Community help: http://wiki.bestpractical.com
> Commercial support: sales at bestpractical.com
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> Buy a copy at http://rtbook.bestpractical.com