Redshift in grafana by Postgres

Please help us how to connect to redshift from grafana by Postgres datasource.

Host : postgres://un:pw@sever.redshift.amazonaws.com:5439
Database :
User :
Password: <combination of alphabets and letters;no special characters>
SSL Mode : Verify-ca

Error :

t=2017-12-20T14:46:45+0000 lvl=eror msg=“Request Completed” logger=context userId=3 orgId=1 uname=*****@.com method=POST path=/api/tsdb/query status=500 remote_addr=127.0.0.1 time_ms=52 size=217 referer=https://******.in/datasources/edit/23

@mefraimsson @torkel
Could anyone please help on it

Hi,

Please try and remove the postgres:// from the host field.

Marcus

After removing postgres:// from the host field.

It should work with redshift (see here for an example: AWS Redshift using Postgres fails to connect)

What do you have in the host field? You should only need sever.redshift.amazonaws.com:5439 and then the user field should contain the username and the password field should contain the password.

Grafana builds the connection string from the fields.

image

Error:
t=2017-12-20T17:15:26+0000 lvl=eror msg=“Request Completed” logger=context userId=3 orgId=1 uname=************** method=POST path=/api/tsdb/query status=500 remote_addr=127.0.0.1 time_ms=29 size=257 referer=https://******.in/datasources/edit/23

sever.redshift… is just an example host url. What is your actual host url for your redshift cluster?

http://docs.aws.amazon.com/redshift/latest/mgmt/connecting-from-psql.html

Thanks Daniellee im able to connect now

1 Like