PostgreSQL also known as Postgres, is a free and open-source relational database management system (RDBMS) emphasizing extensibility and SQL compliance. PostgreSQL features transactions with Atomicity, Consistency, Isolation, Durability (ACID) properties, automatically updatable views, materialized views, triggers, foreign keys, and stored procedures. It is designed to handle a range of workloads, from single machines to data warehouses or Web services with many concurrent users.

Read more about its features and how to get started with the popular platform here.

Step By Step Guide

Step 1

Click on Data Warehouses tab in the left side bar navigation to reach the Data Warehouses Module as shown below.

Add New Warehouse
Step 2

Click on Add New to add an additional Data Warehouse to your account.

Step 3

Select PostgreSQL from the Storage Type drop down options.

Choose PostgreSQL
Step 4

Enter the details about your PostgreSQL in the form and click on Save to add the warehouse. An explanation of each of the fields in the form has been given below.

PostgreSQL Form
Field Description

Data Warehouse Name


Provide a name for your warehouse. It needs to be unique across your account. This can be accessed from the Warehouses Tab.

Host Name


Provide a host name for your warehouse. PostgreSQL hostname defines the location where your PostgreSQL database is hosted. You need to specify the PostgreSQL hostname so that DataChannel knows where to connect.



Provide a username which will be used to create the tables and load data. This user needs to have all rights on the database, datawarehouse(only usage), and the schema you intend to use. In case you are creating a dedicated schema for the data from DataChannel (which is recommended,then this user can be the schema owner.



Provide the password for the username entered above.



Provide the port number.

DB Schema


Provide the database schema where DataChannel should push the data. It is recommended to create a new schema for DataChannel in your database.

DB Name


Provide the name of the database you have created in your PostgreSQL instance.

Still have Questions?

We’ll be happy to help you with any questions you might have! Send us an email at

Subscribe to our Newsletter for latest updates at DataChannel.