PostgreSQL

Last updated on Jan 16, 2023

PostgreSQL is a powerful, open source object-relational database system that uses the SQL language combined with many features that safely store and scale complicated data workloads. PostgreSQL is compatible with all major operating systems.

Hevo can load data from any of your Pipelines into a PostgreSQL database. Follow the steps in this page to add PostgreSQL as a Destination.

If you are new to PostgreSQL, you can follow the steps listed below to install and set up a PostgreSQL instance, and then create a database to which the Hevo Pipeline must load the data. You can also create users and grant them the necessary permissions to set up and manage the PostgreSQL databases.


Destination Considerations

  • You must disable any foreign keys defined in the target tables. Foreign keys do not allow data to be loaded until the reference table has a corresponding key defined.

  • You can replicate data for only 1594 columns in a given PostgreSQL table. Read Limits on the Number of Columns.


Limitations

None.



Revision History

Refer to the following table for the list of key updates made to this page:

Date Release Description of Change
Jan-10-2023 2.05 Added sections, Installing PostgreSQL and Creating a Database Cluster and Database to help set up a PostgreSQL Destination.
Sep-07-2022 NA Updated the Prerequisites section and added the Create a Database User and Grant Privileges section.
Feb-21-2022 1.82 Updated section, Configure PostgreSQL Connection Settings to provide support for SSL in PostgreSQL as a Destination.
Jul-12-2021 NA Updated section, Destination Considerations.

Tell us what went wrong