PostgreSQL - Jobo Enterprise

Connection Configuration

Field	Type	Required	Description
`host`	string	✅	Database server hostname or IP address
`port`	number	✅	Database port (default: 5432)
`database`	string	✅	Database name
`schema`	string	—	Schema name (default: `public`)
`username`	string	✅	Database username
`password`	string	✅	Database password
`ssl_mode`	enum	—	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

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;

Allow network access

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

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.

​Connection Configuration

​Example Configuration

​Setup Requirements

Connection Configuration

Example Configuration

Setup Requirements