This can help avoid confusion when running multiple instances on the same server, or when moving or reinstalling the client.
The chartio_setup wizard will walk you through setting up a readonly user and connecting to Chartio. Then, you'll be given you a link to visit your dashboard and see some charts being automatically generated.
Alternatively, you can download and install the Chartio Connection Client source yourself:
curl https://chartio.com/static/src/chartio-latest.tar.gz -o chartio-latest.tar.gz
tar xvzf chartio-latest.tar.gz
sudo python setup.py install
If your PostgreSQL database is hosted on Amazon RDS, Heroku or another hosting service that does not allow shell access to the database instances, you won't be able to use the Connection Client and will instead need to connect directly. If your database is on Amazon RDS, please visit the RDS setup documentation to first enable Chartio to your security group before following these steps.
In your Project Settings, select Data Source from the left column, then select Add a New Data Source. You'll be redirected to the list of connection options, where you can choose PostgreSQL to connect your PostgreSQL database.
You'll be redirected to a form to enter your database connection information.
If you have issues connecting with Chartio, the exact PostgreSQL or connection errors should be displayed for you as form errors when submitting. If you are unclear on what the error messages mean or how to fix them, do not hesitate to email us at firstname.lastname@example.org.
If you have already established a database connection but something is going wrong, please read our documentation on database connection debugging.