Docker Postgresql remote access

Question

PostgreSQL 13 is running on a remote machine in a docker container. I can't get access to it remotely in any way, the error is

no pg_hba.conf entry for host,

ssl is disabled.

Connect from the local machine by the host name localhost or 127.0.0.1 is excellent. But if I set a own IP of the current server 192.168.1.102 - I am getting the error. And from any remote machine it is the same

postgresql.conf

listen_addresses = '*'

pg_hba.conf

# TYPE  DATABASE        USER            ADDRESS                 METHOD

# "local" is for Unix domain socket connections only
local   all             all                                     trust
# IPv4 local connections:
#host    all             all             127.0.0.1/32           trust
host     all             all             all                    trust
# IPv6 local connections:
host     all             all             ::1/128                trust
# Allow replication connections from localhost, by a user with the
# replication privilege.
local   replication     all                                     trust
host    replication     all             ::1/128                 trust

host all all all md5

I did a container restart and the postgres user has a password

Thanks

Sachith Muhandiram · Accepted Answer · 2021-09-07 14:49:53Z

3

Try use

docker run --publish=192.168.1.102:<exposed-port>:<container-port> postgresql-image

Also make sure you can ping to IP from other PC. Firewalls, Virus guards etc should check.

There are a great number of solutions described here

answered Sep 7, 2021 at 14:49

Sachith Muhandiram

2,97811 gold badges54 silver badges113 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Docker Postgresql remote access

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related