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
