Install the dictionaries into the right place

• cd ~/.software/oddb.org
• sudo cp ext/fulltext/data/dicts/german/fulltext.affix /usr/share/postgresql/tsearch_data/german_fulltext.affix
• sudo cp ext/fulltext/data/dicts/german/fulltext.stop /usr/share/postgresql/tsearch_data/german_fulltext.stop
• sudo cp ext/fulltext/data/dicts/german/fulltext.dict /usr/share/postgresql/tsearch_data/german_fulltext.dict

and do the same for French.

Also Note:

• http://dev.ywesee.com/Yasu/20130314-repair-fulltext-index-dictonary-of-postgresql#Version8.3

For upgrading TSearch2 for Postgres8.3

• via http://www.dzone.com/snippets/tsearch2-upgrade-postgresql-81

Postgres commands to remember

• psql -U postgres oddb.org.ruby193
• \dt display tables
• \l list databases
• \q exit