[rt-users] migrating from MySQL to Postgres?

[Ruslan Zakirov]

Hi,

Here is the page from the archive:
http://wiki-archive.bestpractical.com/view/MySQLToPg

Strange that we skipped it during wikia migration.

On Fri, Jun 24, 2011 at 7:12 PM, Dario Landazuri
<dario at astro.as.utexas.edu> wrote:
> 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
> ************************************************************
>
>
>
> --------
> 2011 Training: http://bestpractical.com/services/training.html
>



-- 
Best regards, Ruslan.