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 for libpq.
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 others. Is one method faster than the other, or easier to maintain?