Store custom files on heroku postgres database

Question

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?

RangerRanger · Accepted Answer · 2019-12-12 16:13:21Z

3

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.

answered Dec 12, 2019 at 16:13

RangerRanger

2,5132 gold badges20 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Chris Over a year ago

And this isn't unique to Heroku Postgres. Most hosted PostgreSQL services won't permit this. If you want that level of control, administer your own instance on a VPS or something. Alternatively, write a stored procedure instead of using unaccent. Stored procedures should work just fine on Heroku Postgres.

Naufal Khalid Over a year ago

@Chris. I am thinking about writing a stored proc as well. Thanks!

Collectives™ on Stack Overflow

Store custom files on heroku postgres database

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related