Connect to PostgreSQL on Zapier
PostgreSQL uses custom authentication to authenticate your account on Zapier. To connect to PostgreSQL, you’ll need to provide a static IP address listed below.
Required authentication fields
Host: This is your database instance's IP address or hostname (db.example.com). It must be accessible from outside your network. Note:
127.0.0.1are not valid. Make sure it is accessible from these IPs:
- Port: 5432 is the default. Change it if you're using a non-standard port.
- Database: This is the name of the database to read data from.
- Schema: This is the schema inside PostgreSWL to search for tables.
- Username: This is the username that will access the database. You should create a new Zapier-specific user with a limited permission scope.
Optional authentication fields
- Password: This is the password of the database to read data from.
- Enforce encryption: Select from the dropdown menu to enforce SSL/TTL for encrypting communication between Zapier and your database.
- SSL client certificate: Use if your server requires client validation for SSL.
- SSL private key: Use if your server requires client validation for SSL.
- SSL CA bundle: Use to provide a PEM-formatted certificate chain file. This is also known as a Certificate Authority (CA) file or CA Bundle.
About PostgreSQL's app
|Are self-hosted or cloud-hosted accounts supported?||Self-hosted and cloud-hosted accounts|
|Is a paid PostgreSQL plan required?||No|
|Are any special account permissions required?||Yes||
You must allow Zapier to connect in:
|Are there usage limits?||N/A|
|Are there pagination limits?||N/A|
|Do trigger samples use real data from your account or generic data?||Real sample data|
|Are custom fields supported?||Yes|
|Do update actions overwrite or append to existing data?||Overwrite existing data|
|Is there any additional info?||Yes|