Improvado
Esc

Start typing to search.

Improvado
Sign In

PostgreSQL Destination

Updated on Jun 30, 2025

Note: This article covers PostgreSQL Destination setup process. This guide doesn’t cover the DataPrep setup for PostgreSQL.

You can learn how to extract data from PostgreSQL Data source here.

Description

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.

Setup guide

Follow our setup guide to connect PostgreSQL to Improvado.

Permissions

Grant the following permissions:

  • CREATE
  • ALTER TABLE
  • SELECT
  • INSERT
  • DELETE

Complete configuration

On the 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.
  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 PostgreSQL.
  1. Select the necessary Use static IP option from the dropdown.
  1. Select the necessary Use binary strings option from the dropdown.

Table partitioning

A table loaded into the 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 PostgreSQL.

Important

  • By default, Improvado uses Daily partitioning - one partition contains data for a certain day.
  • The main partitioned table (e.g., google_analytics) is a virtual table, meaning it does not store any data itself and only connects all date-partitioned tables. These tables cannot be deleted, as doing so would cause the main partitioned table to stop working. Learn more here.

Was this article helpful?