This is a Jitsu.Classic documentation. For the lastest version, please visit docs.jitsu.com. Read about differences here.

📜 Configuration

Configuration UI

Jitsu Internals

Jitsu Server

Postgres

Overview

The Postgres source can sync tables from Postgres SQL database into destination of your choice.

The source is using Airbyte docker image (@airbyte/source-postgres). Learn more how Airbyte-based sources work

How to connect

Please read setup guide for more information.

Connection Parameters

ParameterDocumentation
host*
string
(required)
Hostname of the database.
port*
integer
(required)
Port of the database.
database*
string
(required)
Name of the database.
username*
string
(required)
Username to use to access the database.
password
string
(not required)
Password associated with the username.
ssl
boolean
(not required)
Encrypt client/server communications for increased security.
replication_method
object
(not required)
Replication method to use for extracting data from the database.
tunnel_method
object
(not required)
Whether to initiate an SSH tunnel before connecting to the database, and if so, which kind of authentication to use.