Skip to content
thorntale

Postgres Integration

Connect to Postgres

Add a Postgres datasource from the new datasource page.

add postgres

Fill in the fields and click the Add Datasource button.

  • Datasource Name is a human-readable display name for this datasource.
  • Details is for your own notes, and supports markdown formatting. We suggest recording the relevant tables and schemas here for later reference.
  • Database Address is a public address for your postgres db.
  • Username is a user created on your postgres db. We suggest creating a dedicated user with read permissions only.

    • GRANT SELECT ON my-table TO thorntale-user

  • Password is the corresponding password.

We’ll test the connection, and if we can reach your database, we’ll add the datasource.

Troubleshooting

If you’re hitting permission issues, make sure your database is publically accessible. Sometimes, firewalls can prevent Thorntale from connecting to your Postgres.