Remote connection to postgreSQL in docker container

[EmilBraunstein]

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]

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]

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.