Heroku PostgreSQL - ORuban/openiddict-mobile GitHub Wiki

Heroku PostgreSQL

Steps

  1. Install Heroku Postgre app

    Go to https://elements.heroku.com/addons/heroku-postgresql

  2. Prepare the Connection String

    General connection string template could be found on connectionstrings.com

    Minimum version of Connection string should be the following:

    User ID=<User>;Password=<Password>;Host=<Host>;Port=<Port>;Database=<Database>;Pooling=true;Use SSL Stream=True;SSL Mode=Require;TrustServerCertificate=True;"

    Heroku requires the SSL to be enabled.

    To find parameter's values:

    • go to data.heroku
    • select your Postgre app in the list
    • go to 'Settings' tab
    • click 'View credentials' button against 'Database Credentials'

Related links:

  1. Heroku Postgres overview home page.
  2. Heroku PostgreSQL documentation
  3. Connecting to Heroku Postgres Databases from Outside of Heroku documentation article
⚠️ **GitHub.com Fallback** ⚠️