Connect Langsat to your Postgres database

{ TODO: replace with real step-by-step. This is a Phase 2 mock. }

What you’ll need

• A Postgres instance reachable from the internet (or via SSH tunnel)
• Admin access to create a read-only role
• Your database credentials

Step 1 — Create a read-only role

CREATE ROLE langsat_ro WITH LOGIN PASSWORD '...';
GRANT CONNECT ON DATABASE yourdb TO langsat_ro;
GRANT USAGE ON SCHEMA public TO langsat_ro;
GRANT SELECT ON ALL TABLES IN SCHEMA public TO langsat_ro;

Step 2 — Whitelist our egress IP

Add our Singapore NAT gateway IP to your DB security group. You’ll find the current IP in Project → Settings → Connectors.

Step 3 — Add the connection in Langsat

Project → Connectors → New connection → Postgres. Paste the host, port, DB name, role, and password.

Step 4 — Pick tables and sync

Check the tables you want, click Sync. Langsat streams to Parquet in your private S3 space.

Step 5 — Train

Treat the synced tables exactly like uploaded files. Define a task, click train, done.

{ TODO: add screenshots, SSH tunnel option, and troubleshooting section. }