I’m wonder how most people securely connect to a Postgres database on a
server separate from the app server.
The ActiveRecord docs for a MySQL connection have explicit SSL options,
whereas with Postgres it seems one would pass SSL options as documented
However a quick Googling returns SO threads with suggestions to use SSH
tunnels. Which I guess could be managed with something like AutoSSH.
I’d love to hear from anyone with experience with this. Is one method
faster than the other, or easier to maintain? —Thanks!