Back to Integrations
Integration Guide

Connecting PostgreSQL

A guide to whitelisting our IPs and connecting your Postgres database for direct data ingestion.

What you'll need

Host & Port

Publicly accessible hostname/IP and port (default 5432).

Credentials

Database username and password with read access.

Database Name

The specific database to connect to.

1

Prepare User & Permissions

It is recommended to create a dedicated read-only user for SpendSignal.

-- Create a read-only user
CREATE USER spendsignal_readonly WITH PASSWORD 'secure_password';

-- Grant connect permission
GRANT CONNECT ON DATABASE your_db_name TO spendsignal_readonly;

-- Grant usage on schema (e.g., public)
GRANT USAGE ON SCHEMA public TO spendsignal_readonly;

-- Grant select on all tables (or specific ones)
GRANT SELECT ON ALL TABLES IN SCHEMA public TO spendsignal_readonly;
2

Whitelist IP Addresses

Ensure your database firewall or AWS Security Group allows incoming connections from SpendSignal IP addresses:

  • 34.123.456.78
  • 34.987.654.32
3

Enter Connection Details

Returns to the dashboard form and enter the host, port, db name, user, and password you configured.

Ready to connect?

Head back to the dashboard to test the connection.