I am trying to create custom rules for the builtin function unaccent on postgres. Postgres' documentation states This file must be stored in $SHAREDIR/tsearch_data/ (where $SHAREDIR means the PostgreSQL installation's shared-data directory). Its name must end in .rules (which is not to be included in the RULES parameter). It is easy to create on my local data base but I am wondering, how can I do it on heroku?
There is no way to upload supporting files to the fs on the database host for Heroku Postgres. Heroku Postgres simply does not support this level of custom configuration. They take care of the vast majority of ops on your behalf but it does limit what they can reasonably allow users to change on the system.