PostgreSQL

Last updated on Sep 03, 2024

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.

The following image illustrates the key steps that you need to complete to configure PostgreSQL as a Destination in Hevo:

PostgreSQL Destination Setup


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.



Revision History

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

Date Release Description of Change  
Aug-19-2024 NA Updated sub-section, Grant privileges to the user to update the command.  
Mar-18-2024 2.21.2 Updated section, Configure PostgreSQL Connection Settings to add information about the Load all CA certificates option.  
Apr-25-2023 2.12 Updated section, Configure PostgreSQL Connection Settings to add information that you must specify all fields to create a Pipeline.  
Mar-23-2023 NA Updated section, Grant privileges to the user with new command.  
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