Documentation

Heroku PostgreSQL

Updated on

Sep 5, 2024

Note: Heroku PostgreSQL is currently supported only as a Destination. This guide doesn’t cover the DataPrep setup for Heroku PostgreSQL.

Description

Heroku PostgreSQL is an advanced open-source relational database management system. It offers ACID compliance, support for complex queries, and a thriving community contributing to its continuous development.

Schema information

Setup guide

Follow our setup guide to connect Heroku PostgreSQL to Improvado.

Permissions

You should have write access to the database and the following permissions:

  • ```CREATE```
  • ```ALTER TABLE```
  • ```SELECT```
  • ```INSERT```
  • ```DELETE```

Complete configuration

On the Heroku PostgreSQL connection page, fill in the following fields:

  1. Enter a name for your Destination connection in the Title.
  2. Enter the Host.
  3. Enter the Port.
  4. Enter the User Name. {%dropdown-button name="user-name"%}

{%dropdown-body name="user-name"%}

User Name cannot be any of the following: ```admin```, ```root```, ```postgres```

{%dropdown-end%}

  1. Enter the Password.
  2. Enter the Database Name.
  3. Specify the Schema of your database.
  4. (Optional) Upload your SSL Certificate to connect to Heroku PostgreSQL. {%dropdown-button name="ssl-certificate"%}

{%dropdown-body name="ssl-certificate"%}

You can find more information about it here.

{%dropdown-end%}

  1. Select the necessary Use static IP option from the dropdown. {%dropdown-button name="use-static-ip"%}

{%dropdown-body name="use-static-ip"%}

Select Yes for Use static IP option if you allow Improvado to connect your database by the static IPs mentioned on the Destination connection page.

Select No if you have permitted access to your database from any IP. In this case, Improvado will connect your database using dynamic IPs not listed on the Destination connection page.

{%dropdown-end%}

Table partitioning

A table loaded into the Heroku PostgreSQL database consists of data blocks called partitions, making it easier to manage and query your data. All these partitions form a Partitioned table that aggregates all data.

Learn more about table partitioning in Heroku PostgreSQL.

{%docs-informer info title="Important"%}

By default, Improvado uses Daily partitioning - one partition contains data for a certain day.

{%docs-informer-end%}

Settings

No items found.

Troubleshooting

Troubleshooting guides

Check out troubleshooting guides for
Heroku PostgreSQL
here:

Limits

Frequently asked questions

No items found.
☶ On this page
Description
Related articles
No items found.
No items found.

Questions?

Improvado team is always happy to help with any other questions you might have! Send us an email.

Contact your Customer Success Manager or raise a request in Improvado Service Desk.