How to Connect PostgreSQL with Pabbly Connect

Table of Contents​

1. Overview
2. Important Security Requirement
3. Before You Start (Prerequisites)
4. Allow IP for Cloud-Hosted PostgreSQL
5. Allow IP for Self-Hosted PostgreSQL
6. Connect PostgreSQL in Pabbly Connect
7. PostgreSQL Connection Fields Explained
8. Available PostgreSQL Actions in Pabbly Connect
9. Test the Connection
10. Common Problems & Easy Fixes
11. Final Checklist
12. Completion Status

---

1. Overview​

Pabbly Connect allows you to connect your PostgreSQL database and automate tasks like inserting, updating, fetching, and deleting database records — without writing code.

To make this work, your PostgreSQL server must allow access from Pabbly Connect’s integration server.

---

2. Important Security Requirement​

PostgreSQL blocks unknown servers by default.

To connect PostgreSQL with Pabbly Connect, you must allow the following IP address:

Pabbly Integration Server IP: 157.180.81.74

If this IP is not allowed, PostgreSQL connection will fail.

---

3. Before You Start (Prerequisites)​

Make sure you have:

• A running PostgreSQL database
• Database details:
  • Host
  • Port (usually 5432)
  • Database name
  • Username & password
• Access to your server or cloud provider
• Access to Pabbly Connect

---

4. Allow IP for Cloud-Hosted PostgreSQL​

(AWS RDS, Supabase, Neon, Render, Azure, GCP, etc.)

1. Log in to your cloud provider.
2. Open your PostgreSQL database settings.
3. Go to Security / Firewall / Network Access.
4. Allow this IP address: 157.180.81.74
5. Ensure PostgreSQL port (5432) is allowed.
6. Save the changes.

Cloud PostgreSQL is now accessible from Pabbly Connect.

---

5. Allow IP for Self-Hosted PostgreSQL​

(Server / VM / On-Premise)

5.1 Allow IP in Server Firewall​

Allow incoming traffic from:

157.180.81.74

(This is usually done by your system administrator.)

---

5.2 Allow IP in PostgreSQL Settings​

1. Open the pg_hba.conf file.
2. Add this line:
   
   host all all 157.180.81.74/32 md5
   
   
3. Save the file.
4. Restart or reload PostgreSQL.

PostgreSQL is now ready to connect.

---

6. Connect PostgreSQL in Pabbly Connect​

1. Log in to Pabbly Connect.
2. Create a new workflow or open an existing one.
3. Click Add Action → Select PostgreSQL (Server).
4. Click Add New Connection.
5. Fill in the connection details (explained below).
6. Click Save.

Connection status should show Connected.

---

7. PostgreSQL Connection Fields Explained​

While creating the connection, you will see the following fields:

New Connection Name​

Give a name to identify this connection.
Example: Production PostgreSQL

---

Username​

Enter your PostgreSQL database username.
Example: postgres, admin, db_user

---

Password​

Enter the password for the above username.

---

Database Host​

Enter your PostgreSQL server hostname.

Examples:

• db.example.com
• xyz.supabase.co
• your-db.rds.amazonaws.com

localhost or 127.0.0.1 will NOT work.

---

Database Name​

Enter the name of the database you want to connect to.
Example: prod_db, app_data

---

Database Port​

Enter the PostgreSQL port number.
Default: 5432
(Use a different port only if your server uses one.)

---

SSL Required​

Choose whether SSL is required.

• Yes → Recommended for most cloud databases
• No → Only for local or internal servers

Most cloud PostgreSQL providers require SSL.

---

8. Available PostgreSQL Actions in Pabbly Connect​

Once connected, you can use the following PostgreSQL actions:

Insert Row​

Adds a new row (record) into a table.

---

Update Row​

Updates existing data in a table based on conditions.

---

Get Rows​

Fetches data from a table based on filters or conditions.

---

Delete Rows​

Deletes one or more rows from a table.

Use carefully, as deleted data cannot be recovered.

---

Run SQL Query​

Run a custom SQL query directly on your database.

Examples:

• SELECT queries
• JOIN queries
• Advanced custom logic

Recommended for advanced users.

---

9. Test the Connection​

1. Select any PostgreSQL action.
2. Click Save & Send Test Request.
3. Check the response.

If data is returned or affected successfully, the setup is complete.

---

10. Common Problems & Easy Fixes​

Connection Failed​

• Check IP 157.180.81.74 is allowed
• Verify host and port
• Ensure PostgreSQL is running

Authentication Error​

• Recheck username and password
• Ensure user has database access

Timeout Error​

• Wait a few minutes after allowing IP
• Restart PostgreSQL

---

11. Final Checklist​

✔ PostgreSQL is running
✔ Pabbly IP allowed
✔ Firewall configured
✔ Database credentials verified
✔ Connection tested successfully
✔ Workflow enabled

---

12. Completion Status​

PostgreSQL is successfully connected with Pabbly Connect.
You can now automate your database operations smoothly and securely.