Postgres

Setting up the Postgres connector

No	Item	Required	Example	Notes
1	Host	Yes		Hostname of the database.
2	Port	Yes	5432	Port of the database.
3	Database Name	Yes		Name of the database.
4	Schemas	No		The list of schemas (case sensitive) to sync from. Defaults to public.
5	Username	Yes		Username to access the database.
6	Password	No		Password associated with the username.
7	JDBC URL Parameters (Advanced)	No		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.
8	Connect using SSL	No		Encrypt data using SSL. When activating SSL, please select one of the connection modes.
9	SSL Modes	Yes		SSL connection modes.
Read more in the docs. Refer to the documentation in the form while using the connector disable allow prefer require verify-ca verify-full
10	Replication Method	Yes		Replication method for extracting data from the database. Refer to the documentation in the form while using the connector Standard Logical Replication (CDC)

Zipstack Cloud features a powerful SQL querying engine on top of many types of connectors, including those from Trino, some custom connectors and connectors from the open source Airbyte project. Some Zipstack cloud connectors are designed to utilize and expand upon Airbyte's connector protocol, but they do not use Airbyte's EL core. Additionally, some parts of the documentation for these connectors have been adapted from the connector documentation found in Airbyte's open source project.