title: Azure Postgres Database requires SSL Connection from Corda
body: <p>Using the <a href="https://azure.microsoft.com/en-us/services/postgresql/" rel="nofollow noreferrer">managed Postgres database</a> from Azure a Corda node is unable to connect to the database on start.</p>
  
  <pre><code>    [ERROR] 2019-01-23T11:28:50,937Z [main] internal.Node.run - Exception during node startup {}
  com.zaxxer.hikari.pool.HikariPool$PoolInitializationException: Failed to initialize pool: FATAL: SSL connection is required. Please specify SSL options and retry.
          at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:512) ~[HikariCP-2.5.1.jar:?]
          at com.zaxxer.hikari.pool.HikariPool.&lt;init&gt;(HikariPool.java:105) ~[HikariCP-2.5.1.jar:?]
          at com.zaxxer.hikari.HikariDataSource.&lt;init&gt;(HikariDataSource.java:71) ~[HikariCP-2.5.1.jar:?]
          at net.corda.node.internal.DataSourceFactory.createDataSource(DataSourceFactory.kt:38) ~[corda-node-3.3-corda.jar:?]
          at net.corda.node.internal.DataSourceFactory.createDataSource$default(DataSourceFactory.kt:35) ~[corda-node-3.3-corda.jar:?]
          at net.corda.node.internal.AbstractNodeKt.configureDatabase(AbstractNode.kt:927) ~[corda-node-3.3-corda.jar:?]
          at net.corda.node.internal.AbstractNode.initialiseDatabasePersistence(AbstractNode.kt:695) ~[corda-node-3.3-corda.jar:?]
          at net.corda.node.internal.Node.initialiseDatabasePersistence(Node.kt:347) ~[corda-node-3.3-corda.jar:?]
          at net.corda.node.internal.AbstractNode.start(AbstractNode.kt:207) ~[corda-node-3.3-corda.jar:?]
          at net.corda.node.internal.Node.start(Node.kt:361) ~[corda-node-3.3-corda.jar:?]
          at net.corda.node.internal.NodeStartup.startNode(NodeStartup.kt:203) ~[corda-node-3.3-corda.jar:?]
          at net.corda.node.internal.NodeStartup.run(NodeStartup.kt:126) [corda-node-3.3-corda.jar:?]
          at net.corda.node.Corda.main(Corda.kt:13) [corda-node-3.3-corda.jar:?]
  </code></pre>
  
  <p>My node.conf includes a standard Postgres configuration as recommended in <a href="https://stackoverflow.com/questions/48419854/using-postgresql-instead-of-h2-as-the-corda-nodes-database">this answer</a>.</p>
  
  <pre><code>     dataSourceProperties = {
          dataSourceClassName = "org.postgresql.ds.PGSimpleDataSource"
          dataSource.url = "jdbc:postgresql://[HOST]:[PORT/[DATABASE]"
          dataSource.user = [USERNAME]
          dataSource.password = [PASSWORD]
      }
      database {
          schema = "corda"
          transactionIsolationLevel = "READ_COMMITTED"
      }
  </code></pre>
  
  <p>How can I ensure Postgres is connecting over SSL?</p>