Prerequisites
- A PostgreSQL server reachable from the internet (or through your network configuration).
- A database user with read access to the schemas and tables you want to query.
Required fields
| Field | Description | Example |
|---|---|---|
| Name | A display name for this datasource in Mora. | Graphics Press warehouse |
| Host | The hostname or IP address of your PostgreSQL server. | localhost |
| Port | The port PostgreSQL is listening on. | 5432 |
| Database | The name of the database to connect to. | my_database |
| User | The database user. | admin |
| Password | The user’s password. |
Optional fields
| Field | Description |
|---|---|
| SSL | Enable SSL for encrypted connections. Turn this on if your server requires or supports TLS. |
Steps
- Open Settings → Datasources → New.
- Enter a name and select PostgreSQL as the type.
- Fill in the fields above.
- Click Test connection to verify Mora can reach your database.
- Click Create.
Troubleshooting
- Connection refused — Confirm the host, port, and that your firewall allows inbound connections from Mora’s IP.
- Authentication failed — Double-check the user and password. Ensure the user has
CONNECTprivilege on the database. - SSL required — Toggle the SSL switch on and retry.
Related
- Catalog sync — how Mora discovers your schemas and tables.
- Managing datasources — edit, re-test, or delete.