Skip to main content

​
Connection Configuration

FieldTypeRequiredDescription
hoststring✅Database server hostname or IP address
portnumber✅Database port (default: 5432)
databasestring✅Database name
schemastring—Schema name (default: public)
usernamestring✅Database username
passwordstring✅Database password
ssl_modeenum—SSL mode: disable, allow, prefer (default), require, verify-ca, verify-full

​
Example Configuration

{
  "host": "db.example.com",
  "port": 5432,
  "database": "jobs_db",
  "schema": "public",
  "username": "jobo_feed",
  "password": "••••••••",
  "ssl_mode": "require"
}

​
Setup Requirements

1

Create a dedicated database user

Create a user with only CREATE TABLE, INSERT, and UPDATE permissions on the target schema. Never use a superuser account. sql CREATE USER jobo_feed WITH PASSWORD 'your_secure_password'; GRANT CONNECT ON DATABASE jobs_db TO jobo_feed; GRANT USAGE, CREATE ON SCHEMA public TO jobo_feed; GRANT INSERT, UPDATE ON ALL TABLES IN SCHEMA public TO jobo_feed; ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT INSERT, UPDATE ON TABLES TO jobo_feed;
2

Allow network access

Ensure your server allows connections from Jobo’s IP addresses. Contact support for the current IP range to whitelist.
3

Enable SSL

Use ssl_mode: require or higher for production environments. This ensures all data in transit is encrypted.
Your PostgreSQL server must be accessible from the internet or whitelisted for Jobo’s IP range. Contact support for IP details.
The target table is created automatically on first sync if it doesn’t exist. Jobo uses upsert semantics (INSERT ON CONFLICT UPDATE) to deduplicate by job ID.