search

sverhoeven / docker-cartodb

Dockerized CartoDB
BSD 3-Clause "New" or "Revised" License
147 stars 117 forks source link

Remote connection to postgreSQL in docker container #48

Open EmilBraunstein opened 6 years ago

EmilBraunstein commented 6 years ago

Hi,

I hope you can help me with this.

I want to make a remote connection from my local windows-pc (with pgadmin4 and QGIS) to the postgreSQL inside the sverhoeven/cartodb docker container. Normally with a server installation of postgresql (not docker) I would connect to default port 5432 but with the docker run command in your guide, I run the docker with port 80:80 and that port is used. Would the correct way be to run docker multiple ports docker run -p 80:80 -p 5432:5432?

Thanks you.

/Emil

sverhoeven commented 6 years ago

The postgresql server is only listening on the loopback device (or 127.0.0.1 or localhost) of the container, so connecting to it remotely is not possible at the moment.

GISman-Lee commented 5 years ago

Hi Serhoeven,

May I also ask that what is the db_name, username and password of postgresql in the container ? I would like to access to it on the container machine to check the data, just the local access on the same machine.

Thank you very much.