[rt-users] migrating from MySQL to Postgres?

Dario Landazuri dario at astro.as.utexas.edu
Fri Jun 24 11:12:37 EDT 2011


Greetings,

I'm beginning to investigate migrating our RT backing database from 
MySQL to Postgres to more easily take advantage of full text search, 
which a couple of my coworkers really want.

There apparently used to be a page on the wiki for doing this which has 
since been deleted for being out-of-date.  My google-fu looks to be a 
little weak this morning and hasn't turned up much - I have not tried to 
search the list archives directly yet.  I was wondering if anyone has 
done this and has notes or advice to offer.

I'm looking at installing pg 8.4 packaged by Red Hat (the system is 
running RHEL5) and looking at using one of the tools (probably the one 
from PostgreSQL themselves) here: 
http://wiki.postgresql.org/wiki/Converting_from_other_Databases_to_PostgreSQL#MySQL

Advice?

Cheers,
Dario

-- 
************************************************************
Dario Landazuri                    dario at astro.as.utexas.edu
Systems Administrator                         (512) 471-3334
McDonald Observatory
************************************************************

-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 6558 bytes
Desc: S/MIME Cryptographic Signature
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20110624/c47b0037/attachment.bin>


More information about the rt-users mailing list