I am not super skilled with docker.
Using older versions of Redash (such as 0.12.0+b2449 ), I was able to connect to the Redash metadata database in Postgresql from another EC2 instance. We have a need to sometimes query the Redash database to pull data out of the queries table.
I’m now running Redash Version: 8.0.0+b32245 and from another EC2 instance I’m receiving the “psql: could not connect to server: Connection refused” message:
# psql -h [redash-ec2-instance-private-ip-address-here] psql: could not connect to server: Connection refused Is the server running on host "[redash-ec2-instance-private-ip-address-here]" and accepting TCP/IP connections on port 5432?
What I am trying to figure out how to do is connect to the Postgresql service running within docker from another EC2 instance. I think this has to do more with docker than Redash, and just understanding how to configure/expose the Postgresql service/port to other EC2 instances.
$ docker ps ba01fa910376 postgres:9.6-alpine "docker-entrypoint.s…" 3 weeks ago Up 3 weeks 5432/tcp redash_postgres_1
Another option would be to host the Redash database on RDS, but this is a QA environment so I’m looking to avoid the additional compute cost.
Any ideas? I really appreciate any help.
- Redash Version: Version: 8.0.0+b32245
- Browser/OS: Ubuntu 18.04.3 LTS (GNU/Linux 4.15.0-1054-aws x86_64)
- How did you install Redash: Used your us-east-1 AMI “redash-8.0.0-b32245-1-us-east-1 (ami-0d915a031cabac0e0)”