title: Provide SSL certificate to PostgreSQL in a Rails app
body: <p>I have a Rails app on Elastic Beanstalk using an Amazon RDS PostgreSQL instance.</p>
  
  <p>I'd like pg to use SSL to connect to this DB.</p>
  
  <p>Following <a href="http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_PostgreSQL.html#PostgreSQL.Concepts.General.SSL" rel="noreferrer">http://docs.aws.amazon.com/AmazonRDS/[...]</a>, I saved <a href="http://s3.amazonaws.com/rds-downloads/rds-combined-ca-bundle.pem" rel="noreferrer">rds-combined-ca-bundle.pem</a> at <code>/config/ca/rds.pem</code> and my <code>database.yml</code> looks like this:</p>
  
  <pre><code>production:
    adapter: postgresql
    database: &lt;%= ENV['DB_NAME'] %&gt;
    username: &lt;%= ENV['DB_USERNAME'] %&gt;
    password: &lt;%= ENV['DB_PASSWORD'] %&gt;
    host: &lt;%= ENV['DB_ADDRESS'] %&gt;
    port: &lt;%= ENV['DB_PORT'] %&gt;
    sslmode: 'require'
    sslrootcert: 'config/ca/rds.pem'
  </code></pre>
  
  <p>But I have no idea if it's really using SSL: I can change <code>sslrootcert</code> path to anything, and my app is still up. What am I missing?</p>