PostgreSQL

Connect RootCause to a PostgreSQL database to import tables, run custom queries, or query the database directly without importing.

---

Prerequisites

• Hostname or IP, port (default 5432), database name and schema (default public)

• A user with read access to the tables you want, ideally read-only

• Network access from RootCause to the database (firewall rules, VPN)

---

Setting up the connection

1. In the Import Manager, click the PostgreSQL card

2. Enter your connection details:

Field	Description	Example
Host	Database server hostname or IP	db.example.com
Port	PostgreSQL port	5432
Database	Database name	analytics
Schema	Default schema for queries (optional)	public
Username / Password	Database user	readonly_user
Enable SSL	Encrypted connection, recommended	On

1. Click Test connection to verify, then Save & continue

---

Importing data

Tables: browse schemas and tick one or more tables; each becomes its own source. Custom Query: write SQL to join, filter or aggregate before import.

Tables mode: browse the live schema and tick tables; each becomes its own source.

---

Import modes

All six modes: Full Import, Full Import + Live, Recent Rows, Time Period, Date Range (PostgreSQL is the only connector that offers it) and Query Directly. Rolling windows are resolved by the database itself, so only the selected rows are read. See Connectors for what each mode means.

---

Troubleshooting

Connection timeout

• Check host, port and firewall rules, and that the database accepts remote connections

Authentication failed

• Verify the credentials and that the user has CONNECT on the database and access to the schema

Permission denied on table

• Grant SELECT on the required tables