[rt-users] migrating from MySQL to Postgres?

[Dario Landazuri]

Argh - my apologies, I forgot to say that I'm running RT 4.0.1.

-Dario

> 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/f3e1eb82/attachment.bin>