Create a Heroku connection

Heroku is a cloud platform-as-a-service based on a managed container system. It supports multiple programming languages, has powerful integrated data services and mighty ecosystem that allows developers deploy and run modern apps. dbForge Data Compare for PostgreSQL has implemented support for Heroku.

Heroku app

Each Heroku-based PostgreSQL database has a corresponding Heroku application. The database is attached to the Heroku app and can be accessed through an app config var that contains the database URL.

Create a database connection

1. Open the Database Connection Properties dialog by any of the following ways:

  • On the Database menu, select New Connection.
  • Click the New Connection button on the Database Explorer toolbar.
  • Right-click the Database Explorer window and select New Connection on the menu.

New Connection

2. On the General tab, specify your database connection properties.

  • Host - the name or IP address of the PostgreSQL Server host.
  • Port - the TCP/IP port to connect to the PostgreSQL Server.
  • User - the name of the user account on the PostgreSQL Server.
  • Password - the password of the user account on the PostgreSQL Server.

To get all database connection properties from Heroku CLI, invoke your process as follows:

DATABASE_URL=$(heroku config:get DATABASE_URL -a test-app)

To get all database connection properties from Heroku Console, go to the Settings tab and click the Reveal Config Vars button.

Reveal Config Vars

3. Switch to the Security tab, check Use security protocol, and select Use SSL.

Security tab - Use SSL

Note

You can specify the location of the certificates in the corresponding fields, but this is optional.

4. Optional: To test the created connection, click the Test Connection.

5. Click OK to establish the database connection.