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)?<br>
<br>Thanks.<br><br><div class="gmail_quote">On Tue, Jun 28, 2011 at 5:40 PM, Dario Landazuri <span dir="ltr"><<a href="mailto:dario@astro.as.utexas.edu">dario@astro.as.utexas.edu</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
Greetings,<br>
<br>
Some progress has been made on this front. I have made some slight edits to Edward Groenendaal's script found here: <a href="http://wiki-archive.bestpractical.com/view/MySQLToPg" target="_blank">http://wiki-archive.bestpractical.com/view/MySQLToPg</a> 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.<br clear="all">
</blockquote></div><br>-- <br>James Moseley<br><br>