Thread:Project:Support desk/PostgreSQL and the database search

Hi,

in r81132 – http://svn.wikimedia.org/viewvc/mediawiki/trunk/phase3/includes/search/SearchPostgres.php?r1=80612&r2=81132&pathrev=81132&diff_format=u – you dropped support for “pre-8.3 search”. We’re currently using a hack where we have to set $prefix='default' even on PostgreSQL 8.3 because the Wiki search does not otherwise work:

https://evolvis.org/tracker/t_follow.php/1031

This is Mediawiki 1.15.x on Debian Lenny (PHP 5.2.6, PostgreSQL 8.3.14), which has been upgraded from a much older installation (hence, the old search “lemmatisations”). Links to the problem are included in the problem description in the above bugtracker item.

Now the aforementioned changeset removes support for this from MediaWiki, and before we can upgrade that, we must somehow fix (regenerate?) the search index. How to do this?