Postgres Source

Configure Postgres as a source for your data transfers in Pontoon.

Prerequisites

Before configuring Postgres as a destination, ensure you have:

• Postgres Server: Running Postgres instance (local or cloud)
• Database: Target database for storing data
• User Credentials: Database username and password
• Network Access: Network connectivity to Postgres

Configuration

Connection Details

Parameter	Description	Required	Example
hostname	Postgres host address	Yes	my-postgres-host.com
port	Postgres port	Yes	5432
database	Target database name	Yes	analytics
user	Database username	Yes	pontoon_user
password	Database password	Yes	your_password

Setup Instructions

Step 1: Create PostgreSQL Resources

Create Database and User

-- Create database
CREATE DATABASE analytics;

-- Create user
CREATE USER pontoon_user WITH PASSWORD 'your_secure_password';

-- Create schema
CREATE SCHEMA raw_data;

-- Grant permissions
GRANT CONNECT ON DATABASE analytics TO pontoon_user;
GRANT USAGE ON SCHEMA raw_data TO pontoon_user;
GRANT CREATE ON SCHEMA raw_data TO pontoon_user;
GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA raw_data TO pontoon_user;
GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA raw_data TO pontoon_user;

-- Grant future permissions
ALTER DEFAULT PRIVILEGES IN SCHEMA raw_data GRANT ALL ON TABLES TO pontoon_user;
ALTER DEFAULT PRIVILEGES IN SCHEMA raw_data GRANT ALL ON SEQUENCES TO pontoon_user;

Step 2: Configure Pontoon

1. Navigate to Sources → New Source
2. Select Postgres as the source type
3. Enter connection details:
4. Click Test Connection to verify
5. Click Save to create the source