Here is the complete solution, I use purely RPMS for the whole OACS, including Aolserver and Postgresql. I assume it should be pretty much the same as the source tarball:
1. copy or symlink the file
/usr/lib/pgsql/pltcl.so
to
/usr/local/pgsql/lib/pltcl.so
2. run the following:
psql -f [server_root]/www/doc/sql/postgres-pgtcl.sql acs postgres
psql -f [server_root]/www/doc/sql/rank-for-search.sql acs postgres
3. check the OpenacsSearch paramenter in the config file (this should have been set to 1 already for RPM).
4. Done! Test it under /bboard...
Sincerely,