Overview

PostgreSQL is an advanced open-source relational database that supports both SQL (relational) and JSON (non-relational) querying. Datazone provides native integration with PostgreSQL databases, allowing you to easily connect and extract data from your PostgreSQL instances.

Connection Parameters

Parameter	Required	Description
Name	Yes	A unique identifier for your PostgreSQL source
Host	Yes	The hostname or IP address of your PostgreSQL server
Port	Yes	The port number on which PostgreSQL is running (default: 5432)
Database Name	Yes	The name of the database you want to connect to
Schema Name	No	Optional schema name (if different from the default ‘public’ schema)
User	Yes	Username with appropriate permissions to access the database
Password	Yes	Password for the specified user

Required Permissions

The PostgreSQL user account needs the following permissions:

SELECT - For reading data from tables
USAGE - For accessing schemas
CONNECT - For connecting to the database

Limitations

Be aware of the following limitations when working with PostgreSQL sources:

Supported PostgreSQL versions: 9.6 and above
Some PostgreSQL-specific types will be converted to standard types

Next Steps

After configuring your PostgreSQL source:

Create extracts to specify which tables to ingest
Configure scheduling for recurring extracts
Integrate the source into your data pipelines

For more information about working with extracts and pipelines, refer to their respective documentation sections.

Get Started

Reference

Deployment

Tutorial

PostgreSQL

Overview

Connection Parameters

Required Permissions

Limitations

Next Steps

​Overview

​Connection Parameters

​Required Permissions

​Limitations

​Next Steps

Overview

Connection Parameters

Required Permissions

Limitations

Next Steps