I just installed MultiRepoSearchPlugin and after following the instructions I got to the following error:
omega# trac-admin /var/trac/tcsnp multireposearch reindex_all
Repo DOES need reindexing
Fetching content at development/tcsnp/Makefile.PL
OperationalError: index row size 7280 exceeds btree maximum, 2713
HINT: Values larger than 1/3 of a buffer page cannot be indexed.
Consider a function index of an MD5 hash of the value, or use full text indexing.
Upon further investigation, it seems this is a pretty common error in PostgreSQL, when trying to index a large TEXT column with a btree-type index:
Is this related to the way that MultiRepoSearchPlugin stores data in the schema? (e.g. can it be changed to make it work in Postgres?)
Or maybe you can use full text indexing (instead of btree-indexing) to achieve the same?