Connect to PostgreSQL
Check out our step-by-step video showing how to connect your PostgreSQL database to Chartio:
If your PostgreSQL database is hosted on Google Cloud SQL, Heroku or Amazon RDS, please follow the respective instructions for connecting your instance.
1. Create a PostgreSQL read-only user
The Chartio connection form requires a read-only username and password, which you’ll need to create on your PostgreSQL database before you submit the connection form.
2. Allow Chartio’s IP address
Follow the instructions in the PostgreSQL section of our documentation for how to allow Chartio’s IP address.
3. Connect PostgreSQL to Chartio
You’ll need to provide the following information in Chartio’s PostgreSQL connection form to connect your PostgreSQL database to Chartio:
- Hostname or IP: where your database is hosted
- Port: default port number for PostgreSQL is
5432 - Username: username of the PostgreSQL read-only user you created previously
- User Password: password of the PostgreSQL read-only user you created
- Database Name: name of your PostgreSQL database
Query comment
To provide more context to where queries to your data source are coming from, Chartio includes metadata to any queries we send; it looks similar to the following:
{
"reason":"chart_editor",
"user_email":"support@chartio.com",
"datasource_id":123456,
"dashboard_slug":"my-dashboard",
"chart_id":1234567,
"datasource_alias":"my data source",
"organization_id":12345,
"dataset_id":1231231,
"is_manual":false,
"dataset_name":"Dataset 1",
"dashboard_id":456456
}