PostgreSQL

Supported Tasks

• Extract

• Load

Fields

Field	Description	Example
Host	The hostname of the PostgreSQL server.	postgresql.example.com
Port	The port the PostgreSQL server is listening on. By default, it's 5432.	5432
Username	The name of the PostgreSQL user.	postgres
Password	The password associated with the specified username.	MyPassword1!
Database	The name of the database to connect to.	my_db
Connect Timeout	The timeout, in seconds, when connecting to the database. By default, it's 30 seconds.	30
SSL Mode	If the database should be connected to via SSL, this should be enabled. For more details on the various SSL modes, check out the PostgreSQL documentation.	Disable
SSL Client Certificate	The SSL certificate for the client connecting to the server. Only required when SSL Mode is enabled.	client-cert.pem
SSL Client Key	The private SSL key for the client. Only required when SSL Mode is enabled.	client-key.pem
SSL Root Certificate	The root SSL certificate for the database server. Only required when SSL Mode is enabled.	server-ca.pem