Possible to create Postgres synonym files?

Some features of Postgres require filesystem access. For example, per the manual, custom full-text search configurations need to read synonym lists from $SHAREDIR/tsearch_data/<filename>

Is it possible to create such a file in Render’s Postgres services?

According to Databases | Render · Cloud Hosting for Developers one of the pre-installed extensions is dict_xsyn, which I think really only makes sense if you can create these files.

I’m not getting my hopes up too high, though – both AWS RDS (hxxps://forums.aws.amazon.com/thread.jspa?threadID=143920) and GCP Cloud SQL (hxxps://issuetracker.google.com/65624669) also have this issue :slight_smile:

You are right, it seems that in order to make use of dict_xsyn you would need file system access to create the rules file. Currently, file system access is not possible and you will not be able to take advantage of the extension at this time.

I suggest you create a feature request https://feedback.render.com/, and we can look at making this possible in the future.

1 Like

thanks for the speedy reply! I’ve created a feature request. This is just a nice to have - I can work around it with some preprocessing that happens outside of postgres, it’ll just be a bit more fragile.

1 Like