Problem
- Im not able to connect to postgres db inside docker container from host. Im making simple crud app with node.js so managing db from inside of container doesn't come into play.
Solutions I've tried
- Im exposing port from container
- running psql as postgres local user on host os
- redirecting 5432 to different local port
Im running postgres container with: docker run --name postgres -p 5432:5432 -e POSTGRES_PASSWORD=secret -e POSTGRES_USER=postgres -d postgres
when running psql -h (localhost or 127.0.0.1) -p 5432 -U postgres I get "psql: error: connection to server at "127.0.0.1", port 5432 failed: server closed the connection unexpectedl This probably means the server terminated abnormally before or while processing the request."
additional info: docker container ps -a -> f596d7350e9c postgres "docker-entrypoint.s…" 6 seconds ago Up 5 seconds 0.0.0.0:5432->5432/tcp, :::5432-> 5432/tcp postgres
ss -lntp -> LISTEN 0 32 192.168.100.1:53 0.0.0.0:* LISTEN 0 4096 0.0.0.0:5432 0.0.0.0:* LISTEN 0 4096 [::]:5432 [::]:*
I know there are bunch of similar questions asked prior to similar problem but they don't seem to solve problem in my case. ex: Connecting to Postgresql in a docker container from outside
I've been trying to fix this issue for past 2 days im stuck at this point.