I would like to share with you the simple step to fix below error when trying to start or configuring the
postgresql database. This was tested on CentOS 5.5 x86_64 bit.
Symptoms:
ERROR : Could not find tsearch2.sql file
Solution/Fix:
yum install postgresql-contrib