I'm considering porting a MySQL database over to PostgreSQL that includes full text searching. The postgres method of using synonym dictionaries on the search phrase seems incrediably useful rather than having to mess around rewriting queries everywhere else. However all the examples I've seen require the dictionaries to be in the $SHAREDIR which at /usr/share is inaccessible - and seems to preclude each seperate database being able to define it's own dictionaries. Is there are way to supply this information or am I looking at having to run my own database / live without this? asked 08 Apr '11, 03:45 cmdkeen |
Q. Is there are way to supply this information or am I looking at having to run my own database / live without this? A. According to Postgres official docs the SHAREDIR environment variable is what dictates what path a dictionary can be called from,
The default SHAREDIR on our platform is,
As reported by pg_config. You would have to build your own database server to be able to control its settings. answered 08 Apr '11, 04:13 johns |