Connect to Docker Inventree postgres db with pgadmin4?

[mikelemo]

I'm trying to connect to the docker inventree database that has default setting i.e.:

IP: 178.18.0.2
Database: inventree
User: pguser
Password: pgpassword

Fetched the ip using docker ps for the postgres 17 container id and
docker inspect [CONTAINER_ID] to get the

"IPAddress": "172.18.0.2",

with local or docker pgadmin4 but with no luck telling me

Unable to connect to server:
Connection timed out

what am I missing?

[wolflu05]

Please add more details. Where is your db running, from where are you trying to connect to the database, ...

[mikelemo]

Please add more details. Where is your db running, from where are you trying to connect to the database, ...

I'm trying to connect to the docker inventree database that has default setting i.e.:

IP: 178.18.0.2
Database: inventree
User: pguser
Password: pgpassword

with local or docker pgadmin4

... quite straight forward all locally.

[mikelemo]

OK nvm, I Just restarted the system (the ip changed slightly) and now I'm able to connect to it.

[mikelemo]

Actually I'm also to connect to postgres with local pgadmin4 app but not with docker pgadmin in browser which I installed and ran with:

docker pull dpage/pgadmin4
docker network create pg-network
docker run -it \
    -e PGADMIN_DEFAULT_EMAIL="[email protected]" \
    -e PGADMIN_DEFAULT_PASSWORD="mypass" \
    -p 8080:80 \
    --network=pg-network \
    --name pgadmin \
    dpage/pgadmin4

Though I am able to open pgadmin4 in the browser with localhost:8080

[mikelemo]

I hate this docker crap this is so weird.
Now i'm trying to connect to the inventree db using the same credentials as I used with local pgadmin4 app (ubuntu) using
nvim's SQLua and unable to, but when I try to connect to a local postgresql db using nvim SQLua it works fine this docker thingy is so annoying and abstractive...