Ok, now I got everything up and running (had to reinstall Linux)
So, I have my custom made Postgres server and I have the the Redash containers, all running in Docker.
The custom Postgres is setup using following docker-compose.yml
Now as far as I can gather, based on this the parameters that I fill in, in the Redash connect a data source setup, should be:
User: user2 (Or blank, since POSTGRES_HOST_AUTH_METHOD: trust)
Password: example123 (Or blank, since POSTGRES_HOST_AUTH_METHOD: trust)
SSL Mode: (not sure, leaving blank)
Database Name: nw
Have I got this right? However, when I try to connect I get the following error:
could not connect to server: Connection refused Is the server running on host “0.0.0.0” and accepting TCP/IP connections on port 5432?
I know the Postgresserver is listening at 0.0.0.0 and port 5432 because in Docker terminal I can see this after I start it.
db_1 | 2020-11-08 13:05:11.013 UTC  LOG: listening on IPv4 address “0.0.0.0”, port 5432
Any idea what might be wrong?