Redshift in grafana by Postgres

Grafana PostgreSQL
1

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

image
image769×618 110 KB

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

2

@mefraimsson @torkel
Could anyone please help on it

3

Hi,

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

Marcus

4

After removing postgres:// from the host field.

image
image965×103 35.2 KB

5

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.

6

image
image1006×504 146 KB

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

7

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

8

Thanks Daniellee im able to connect now

1 Like