Migrate server, disable and reenabling FullTextIndex

RT Users
1

Hi!

i migrated mi RT instance from rt 5.0.1 and PostgreSQL 9 to RT 5.0.5 and postgreSQL 14.

I don´t know how is configured RTFULLINDEX on the migrated database. So i do it again.

 /opt/rt5/sbin/rt-setup-fulltext-index

But i get and error

[67379] [Wed Feb 28 10:02:54 2024] [warning]: DBD::Pg::db do failed: ERROR:  relation "contentindex_idx" already exists at /opt/rt5/sbin/rt-setup-fulltext-index line 750, <STDIN> line 4. (/opt/rt5/sbin/rt-setup-fulltext-index:750)
[67379] [Wed Feb 28 10:02:54 2024] [critical]: DBD::Pg::db do failed: ERROR:  relation "contentindex_idx" already exists at /opt/rt5/sbin/rt-setup-fulltext-index line 750, <STDIN> line 4. (/opt/rt5/sbin/../lib/RT.pm:409)

How can i “remove” the olf fulltextindex, and redo again?

Regards!!!

2

Can I Delete the old tables and generate it again with rt-setup-fulltext-index?

3

I don´t know if its correct.

I rerun the configuration using new table/Colum names for index. Deleted the old ones. Change the indexing configu on RT_Siteconfig.pm to the new index data.

Regards.