Today

PostgreSQL


PostgreSQL

PostgreSQL

Beta version

The configuration and connection might need a bit of fine-tuning to get things running smoothly. Let us know if you hit any snags at team@tably.com.

Once created, a connection can be reused or copy-pasted in all other pages within same workspace without additional setup. The setup can be complex and, if in doubt, ask your developer for help. They will have all needed details and will be able to assist with possible errors.

Hostname of the database.
Port of the database.
Name of the database.
The list of schemas (case sensitive) to sync from. Defaults to public.
Username to access the database.
Password associated with the username.
Additional properties to pass to the JDBC URL string when connecting to the database formatted as 'key=value' pairs separated by the symbol '&'. (Eg. key1=value1&key2=value2&key3=value3). For more information read about JDBC URL parameters.
SSL connection modes. Read more in the docs.

Always require encryption and verifies that the source database server has a valid SSL certificate.

CA certificate
Client certificate
Client key
Password for keystorage. If you do not add it - the password will be generated automatically.

This is the most secure mode. Always require encryption and verifies the identity of the source database server.

CA certificate
Client certificate
Client key
Password for keystorage. If you do not add it - the password will be generated automatically.
Replication method for extracting data from the database.

Logical replication uses the Postgres write-ahead log (WAL) to detect inserts, updates, and deletes. This needs to be configured on the source database itself. Only available on Postgres 10 and above. Read the docs.

A plugin logical replication slot. Read about replication slots.
A Postgres publication used for consuming changes. Read about publications and replication identities.
The amount of time the connector will wait when it launches to determine if there is new data to sync or not. Defaults to 300 seconds. Valid range: 120 seconds to 1200 seconds. Read about initial waiting time.
The size of the internal queue. This may interfere with memory consumption and efficiency of the connector, please be careful.
Determines when Airbtye should flush the LSN of processed WAL logs in the source database. After loading Data in the destination is default. If While reading Data is selected, in case of a downstream failure (while loading data into the destination), next sync would result in a full sync.
Whether to initiate an SSH tunnel before connecting to the database, and if so, which kind of authentication to use.
Hostname of the jump server host that allows inbound ssh tunnel.
Port on the proxy/jump server that accepts inbound ssh connections.
OS-level username for logging into the jump server host.
OS-level user account ssh key credentials in RSA PEM format ( created with ssh-keygen -t rsa -m PEM -f myuser_rsa )
Hostname of the jump server host that allows inbound ssh tunnel.
Port on the proxy/jump server that accepts inbound ssh connections.
OS-level username for logging into the jump server host
OS-level password for logging into the jump server host
Finish step configuration to see output