PostgreSQL read-only user
The Chartio connection form require a read-only username and password, which you’ll need to create on your PostgreSQL database before you submit the connection form.
Allowing Chartio to connect to your database
By default, PostgreSQL restricts connections to hosts and networks included in the pg_hba.conf file. You may need to add Chartio’s IP address to this file to allow connectivity to your database.
To allow the user ‘chartio_read_only’ to connect to the database ‘mydatabase’ from Chartio’s IP address you would add the following lines to pg_hba.conf:
host mydatabase chartio_read_only 126.96.36.199/32 md5
You may need to restart your PostgreSQL server for the changes to take effect.
For more details on modifying the pg_hba.conf file consult the PostgreSQL documentation.