I’m very new to docker. I’ve been searching for my answer but all i found did not worked.
I have installed docker on my local server (Synology) and ran two linked containers - one for nodejs, the other for postgresql.
I can access in my terminal, with my local IP or my public IP to the postgresql container and create a new db and so on… by accessing my server in ssh, run an instance in my docker container and log with psql.
Now, i would like to access my database with an app like PGadmin or Tableplus on my laptop but it doesn’t work. I’have published the container on my 5431 port and set a POSTGRES_PASSWORD in my environment but I always get this message when i try to connect :
“server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.”
To be honest i don’t know which IP adress i should use so tried with all IP i know. When i type
docker ps it returns :
When I type
docker inspect my-postgres-container, it returns :
Why it doesn’t work ?
Thank you for you help