PostgreSQL full text search plugin for Redmine
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Type Name Latest commit message Commit time
Failed to load latest commit information.
app/models make search config creation more flexible Sep 27, 2015
db/migrate make search config creation more flexible Sep 27, 2015
lib ignore attachments where no project id can be determined Sep 27, 2017
test travis matrix - Ruby 2.4.1, Redmine 3.4; fix test case Jul 14, 2017
.travis.yml travis matrix - Ruby 2.4.1, Redmine 3.4; fix test case Jul 14, 2017
Gemfile.lock initial Sep 16, 2015
LICENSE initial Sep 16, 2015 add information about unaccent extension setup #2 Jan 7, 2016
init.rb fix urls Feb 28, 2017

Redmine PostgreSQL Search Build Status

Makes Redmine search use PostgreSQL full text search instead of LIKE queries.


Follow the generic Redmine plugin installation instructions, but with a twist for Redmine installations with mostly non-english content:

Before running the plugin migrations, set the language environment variable to the language your Redmine content (mostly) is in. The setup_tsearch migration uses this to create a matching text search configuration in your Redmine database. This directly influences search results quality so don't just skip this (unless your language would be english, this is the default used by the migration).

To find out which languages are supported by your PostgreSQL installation, run \dF in a shell:

redmine=# \dF
                List of text search configurations
   Schema   |     Name     |              Description
 pg_catalog | danish       | configuration for danish language
 pg_catalog | dutch        | configuration for dutch language
 pg_catalog | english      | configuration for english language
 pg_catalog | finnish      | configuration for finnish language
 pg_catalog | french       | configuration for french language
 pg_catalog | german       | configuration for german language
 pg_catalog | hungarian    | configuration for hungarian language
 pg_catalog | italian      | configuration for italian language
 pg_catalog | norwegian    | configuration for norwegian language
 pg_catalog | portuguese   | configuration for portuguese language
 pg_catalog | romanian     | configuration for romanian language
 pg_catalog | russian      | configuration for russian language
 pg_catalog | simple       | simple configuration
 pg_catalog | spanish      | configuration for spanish language
 pg_catalog | swedish      | configuration for swedish language
 pg_catalog | turkish      | configuration for turkish language

So if your Redmine installation has mostly German text, you would run

language=german bundle exec rake redmine:plugins:migrate

after unpacking the plugin to YOUR_REDMINE/plugins/redmine_postgresql_search.

After running the migrations, make sure to index all your existing content by running

bundle exec rake redmine_postgresql_search:rebuild_index

In case you want to learn more about the internals of PostgreSQL full text search - I found these two articles quite helpful:

unaccent extension

The setup_tsearch migration attempts to install the unaccent PostgreSQL extension, which may fail due to insufficient privileges of your application's database user. To get around this, set up the extension manually (create extension unaccent) using a privileged user account and re-run the plugin migrations. On Ubuntu/Debian this extension is part of the postgresql-contrib package.

Known Issues

Please report any issues not mentioned here on Github.

Result Completeness

Search on custom fields and journal entries is done separately from search in issues - therefore a search for all words of the query foo bar will not find issues with foo in the description and bar in a journal entry or custom field. The reason is the way Redmine search works on a fundamental level. To make things a little better this plugin indexes the issue's subject along with each journal, so if you have foo in the subject and bar in a journal entry you will find the issue.


Copyright (C) 2015 Jens Krämer

The Postgresql Search plugin for Redmine is free software: you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation, either version 3 of the License, or (at your option) any later version.

The Postgresql Search plugin for Redmine is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.

You should have received a copy of the GNU General Public License along with the plugin. If not, see