or 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 you're 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 you're 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 + New Data Source in the Data Sources column. You'll be brought to the following list of connection options where you can choose PostgreSQL to connect your PostgreSQL database.
You will be brought to a page where you can choose between connecting with the Connection Client or the Direct Connection. Since you're reading this documentation you likely want to use the Direct Connection so select it.
Now you'll see the following form for putting in your connection information.
To connect to PostgreSQL Chartio needs the following information.
host - the host name or IP address of the server your database is hosted on
database name - the name of the database you're connecting
user - the name of a preferably read-only user to your database
password - the password for the read-only user
port - the port that the database is listening to (default: 5432)
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.