[rt-users] Upgrade and migration questions

[Kenneth Marshall]

On Tue, Jan 26, 2010 at 11:52:27AM -0800, Tim Mitchell wrote:
> Does anyone have a link that will let  me know if I can go from 3.4.4 to 3.8.4 directly? System is Ubuntu v6.06 LTS + Postgresql 7.4
> 
> Also any advice about moving from Postgresql to Mysql either before or after the upgrade? 
> 
> Thanks!
> -TM
> 
Hi Tim,

We went from 3.4.5pre1 to 3.8.5, RHEL3 -> RHEL5, PostgreSQL 7.4 ->
PostgreSQL 8.4. It went pretty smoothly following the documented
upgrade steps. The more tedious part was double checking any local
modifications to validate whether they were still needed and to
be certain that the functionality still worked post upgrade.

Moving from PostgreSQL -> MySQL will need a little bit more work.
I think that there is a wiki article and possibly some tools to
help with this process. I do have a question for you. Why are you
moving from PostgreSQL to MySQL instead of updating to the current
PostgreSQL release? For one thing, PostgreSQL will allow you to
use full text indexing to dramatically improve the performance of
full content searching within your tickets and RTFM articles.
This functionality is also available with the Oracle backend. Is
there some problem you are trying to address?

Cheers,
Ken