Although Heroku has put a lot of attention into their own Postgres-based datbase architecture, Heroku Data, this article still works for rebels who want to use Amazon RDS on Heroku:
https://devcenter.heroku.com/articles/amazon-rds
Note that I can’t seem to get “sslca” to work as a config option in my database.yml file (in Rails), I get this I get an error after deploying, upon connection
SSL_CTX_set_default_verify_paths failed
This happens when configuring by database.yml, which I shouldn’t be doing anyway.
Nonetheless, the configuration by DATABASE_URL (which is preferred for security anyway), does actually work.
Although it continues to work in 2018, this may not be good long-term strategy as my last conversations with Heroku support led me to conclude that their failover policies for catastrophic failures aren’t set up for an RDS- backed solution unless you go into Heroku Private Spaces, which you need to be an enterprise client for.