I wanted to ask the same question, so I know if I should do the migration before or after upgrading to RT 4. There are a lot of different methods on that page, and the simplest ones seem to be just dumping the MySQL database and importing it into Postgres. Is there any general consensus regarding which method is "best", with the biggest chance of getting non-corrupted attachments etc.?
/Johan -----Original Message----- From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Patrick Fish Sent: den 4 maj 2011 09:51 To: rt-users@lists.bestpractical.com Subject: Re: [rt-users] Manual for Full-text search I've been debating the same thing...would the procedure shown on the MySQLToPg page on the Wiki still be valid for 4.0.x? Patrick -----Original Message----- From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Johan Sjöberg Sent: Wednesday, May 04, 2011 12:38 AM To: Alex Vandiver Cc: rt-users@lists.bestpractical.com Subject: Re: [rt-users] Manual for Full-text search Hi. Thank you for your reply. We will probably start looking at migrating from MySQL to Postgres, since it seems like that is much better way to go. Looking forward to the full-text search documentation. /Johan -----Original Message----- From: Alex Vandiver [mailto:ale...@bestpractical.com] Sent: den 3 maj 2011 17:53 To: Johan Sjöberg Cc: rt-users@lists.bestpractical.com Subject: Re: [rt-users] Manual for Full-text search On Mon, 2011-05-02 at 13:52 +0000, Johan Sjöberg wrote: > I am currently evaluating RT4 on our RT test-server. I noticed that > improved fulltext-search is one of the things mentioned in the release > notes, and I can also see some settings regarding FullTextSearch in > RT_Config.pm. > > Is there any documentation on how to setup and use this feature? It > would be very useful to us. We will be shipping much-improved documentation on the full-text searching in RT 4.0.1. There is also a sizable bug which prevents it from working on MySQL in RT 4.0.0, which we hope to resolve quickly enough to also land in RT 4.0.1. > We are using MySQL 5.0 The updated documentation will also make clear that as MySQL does not include built-in full-text search capabilities, we rely on the external Sphinx FTS tool. Unfortunately, the SphinxSE engine which allows us to make FTS queries from within MySQL requires recompiling MySQL. You can find complete instructions on how to do this at http://sphinxsearch.com/docs/2.0.1/sphinxse-installing.html - Alex