[rt-users] migrating from MySQL to Postgres?

James Moseley jmoseley at corp.xanadoo.com
Tue Jun 28 18:52:20 EDT 2011


Dario, I apologize for being slightly off-topic, but your original request
stated you wanted to migrate from mysql to postgres to better utilize full
text search.  I'm sure this has been discussed in other threads, but is
their an inherent limitation in mysql that prevents this (ie, you need a lot
more memory, faster disk access, etc, using mysql vs. postgres) function
from working efficiently (or at all)?

Thanks.

On Tue, Jun 28, 2011 at 5:40 PM, Dario Landazuri
<dario at astro.as.utexas.edu>wrote:

> Greetings,
>
> Some progress has been made on this front.  I have made some slight edits
> to Edward Groenendaal's script found here:
> http://wiki-archive.bestpractical.com/view/MySQLToPg that Ruslan pointed
> out.  I am now able to migrate data from my mysql database to a postgres
> one.  I'll post that script tomorrow.
>

-- 
James Moseley
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20110628/62e332fb/attachment.htm>


More information about the rt-users mailing list