Connect Postgres Database to Dbeaver

petitminion

In the docker-compose deployement the db can be accessed by entering the postgres container and connecting to the db without password thank to the "POSTGRES_HOST_AUTH_METHOD=trust" option : sudo docker exec -it ea78e48f47d5 bash ; psql -U postgres.

But this doesn't work when trying to connect to postgres from the localhost :

psql -h 127.0.0.1 -p 5432 -U postgres
Password for user postgres: 
psql: error: fe_sendauth: no password supplied

How I can connect to the postgres db from my local computeur ?

petitminion

I had to use the postgre container ip adress sudo docker inspect -f '{{range.NetworkSettings.Networks}}{{.IPAddress}}{{end}}' e807604ba402 and psql -h 192.168.32.4 -p 5432 -U postgres

gcrk

If you want to access the container via localhost, you'd need to forward the host port to the container. Simply add -p 5432:5432 to your exec statement.

@egon0 can probably give further advice on docker 😉

Since this is probably interesting for general development, we maybe want this to be documented? @Sporiff

Sporiff

gcrk I've opened an issue for this here.

egon0

gcrk Simply add -p 5432:5432 to your exec statement.

I really would prefer -p 127.0.0.1:5432:5432 - usually nobody wants to expose their database to potentially the whole internet 🙃

gcrk

@petitminion just to be sure, is this about something which runs in production or for your local dev setup?

egon0

gcrk Even if I'm tea-bagging here, I really really really would love not to see some open world port-forwardings. Either if it's for development or production. I've seen a so much official documentation that leaves services unnecessary open to world...

petitminion

gcrk
I was using this for dev purposes

gcrk

egon0 Yes, thats not the point of my question, but to evaluate if its useful to document how to do this in production or as part of your local dev setup