Thanks for your help. I'll try the script. Luciano
-----Mensagem original----- De: Jeff Blaine [mailto:jbla...@kickflop.net] Enviada em: quinta-feira, 12 de janeiro de 2012 16:12 Para: Luciano Ernesto da Silva Cc: rt-users@lists.bestpractical.com Assunto: Re: RES: [rt-users] RES: Re: RES: Sphinx fulltext index v4.0.4 On 1/12/2012 12:54 PM, Luciano Ernesto da Silva wrote: > When you migrate to PostgreSQL, what version of RT were you using? RT 4? > Any special option on script? We dumped our RT 3.4.4 database from MySQL 4.1 (this is the last time we touched the old data) We stood up a new host. It had MySQL 5.1.x We loaded the MySQL 4.1 dump into the new MySQL 5.1.x instance We followed docs/UPGRADING.mysql We updated the password salt stuff (docs/UPGRADING.*) Then... We stood up PostgreSQL 8.4.9 on the same server We reconfigured RT for 'Pg', then primed the DB + tables + acls make install sbin/rt-setup-database --action drop # ignore any errors sbin/rt-setup-database --action create sbin/rt-setup-database --action schema sbin/rt-setup-database --action acl Then we migrated the data from MySQL 5.1 (running) to PostgreSQL 8.4.9 (running) with: http://wiki-archive.bestpractical.com/view/rt-mysql2pg There's no magic to the script's options. It has --help > -----Mensagem original----- > De: rt-users-boun...@lists.bestpractical.com > [mailto:rt-users-boun...@lists.bestpractical.com] Em nome de Jeff > Blaine Enviada em: quinta-feira, 12 de janeiro de 2012 15:06 > Para: rt-users@lists.bestpractical.com > Assunto: Re: [rt-users] RES: Re: RES: Sphinx fulltext index v4.0.4 > > On 1/12/2012 9:46 AM, Luciano Ernesto da Silva wrote: >> Tarek, >> >> I already tried migrate from Mysql 5.1 to postgreSQL 9.1 but I had >> some problems quith some charset. Some records in Attachments table >> (from users that send an email in 8859-1) don't get converted to utf8 >> and I get the strange character with letter I with acute, like "í >> "looking to "Â "(there's a space after Â, hidden or not). I don't >> know fix that, do you know any way to do that? I even used sed >> command, but it don't remove the space or whatever this is. > > We had the same problem. > > This worked perfectly for us in the end, though we went to PostgreSQL > 8.4.9 as provided by RHEL 6.x > > http://wiki-archive.bestpractical.com/view/rt-mysql2pg > -------- > RT Training Sessions (http://bestpractical.com/services/training.html) > * Boston March 5& 6, 2012 > -------- RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 & 6, 2012