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: [EMAIL PROTECTED] > > > Discover RT's hidden secrets with RT Essentials from O'Reilly Media. > Buy a copy at http://rtbook.bestpractical.com _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
