Create ts_db, a demo database.
create database ts_db;
Load the Tsearch2 module into the ts_db database.
psql ts_db < /usr/local/pgsql/lib/contrib/tsearch2.sql;