title: How to pass sslmode=require to liquibase
body: <p>We run an application on Heroku and update the Database with Liquibase. Now it seems we have to pass the 'sslmode=require' URL parameter to Liquibase. The DB url itself is taken from the DATABASE_URL environment variable provided by Heroku and then the Liquibase properties are set by the entrypoint.sh script of the container that executes the migration:</p>
  <p>echo &quot;Use DATABASE_URL for configuration&quot;;</p>
  <p>IFS='/'</p>
  <p>read -ra TOKENS  &lt;&lt;&lt; &quot;$DATABASE_URL&quot;</p>
  <p>export LIQUIBASE_DATABASE=${TOKENS[3]}</p>
  <p>IFS='@'</p>
  <p>read -ra CRED_HOST_PORT &lt;&lt;&lt; &quot;${TOKENS[2]}&quot;</p>
  <p>IFS=':'</p>
  <p>read -ra HOST_PORT &lt;&lt;&lt; &quot;${CRED_HOST_PORT[1]}&quot;</p>
  <p>export LIQUIBASE_HOST=${HOST_PORT[0]}</p>
  <p>export LIQUIBASE_PORT=${HOST_PORT[1]}</p>
  <p>read -ra USER_PW &lt;&lt;&lt; &quot;${CRED_HOST_PORT[0]}&quot;</p>
  <p>export LIQUIBASE_USERNAME=${USER_PW[0]}</p>
  <p>export LIQUIBASE_PASSWORD=${USER_PW[1]}</p>
  <p>So, how can we get Liquibase to connect to the Heroku Postgres DB with the sslmode=require query param?</p>