Hi,
I’m testing a new RT4 installation with Postgres to try FullText search. I got RT up and running, ran the rt-setup-fulltext-index utility, updated my RT_SiteConfig file but get errors when trying to run the indexer:
root@rt2:/opt/rt4# sbin/rt-setup-fulltext-index --dba postgres --dba-password ‘’
Enter name of a DB table that will be used to store Pg tsvector. Attachments table can be used.
[Attachments]:
Enter name of a column that will be used to store Pg tsvector
[ContentIndex]:
Configure your RT via site config:
Set( %FullTextSearch,
Enable => 1,
Indexed => 1,
Column => ‘ContentIndex’,
Table => ‘Attachments’,
);
Going to do the following change in the DB:
ALTER TABLE Attachments ADD COLUMN ContentIndex tsvectorYou have choice between GiST or GIN index, the first is times slower to search, but it takes less place and faster to update.
[GiST]:
Going to do the following change in the DB:
CREATE INDEX ContentIndex_idx ON Attachments USING gist(ContentIndex)
root@rt2:/opt/rt4#
root@rt2:/opt/rt4# sbin/rt-fulltext-indexer
[Fri May 20 19:40:14 2011] [warning]: Use of uninitialized value $table in concatenation (.) or string at /usr/local/share/perl/5.10.1/DBIx/SearchBuilder.pm line 1223. (/usr/local/share/perl/5.10.1/DBIx/SearchBuilder.pm:1223)
[Fri May 20 19:40:14 2011] [warning]: Use of uninitialized value $args{“TABLE2”} in concatenation (.) or string at /usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 989. (/usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm:989)
[Fri May 20 19:40:14 2011] [warning]: DBD::Pg::st execute failed: ERROR: relation “_3” does not exist
LINE 1: …) AND ( Transactions_1.ObjectId = main.id ) JOIN _3 ON ( _…
^ at /usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 509. (/usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm:509)
Did I miss something? I read through the RT_Config file comments and the --help flag for all related binaries.
Thanks,
Patrick