Why is there an error when accessing postgresql "User `postgres` was denied access on the database `db.public`"

General Discussions General
1

Why is there an error when accessing postgresql

`User postgres` was denied access on the database `db.public`.

My Postgresql is on local host and my nodejs Application is on container. I have set pg_hba.conf so that docker can access Postgresql. code pg_hba.conf as below.

host    all             all             172.17.0.1/16           md5
host    all             all             10.127.93.219/24     md5

I’ve also set listen_address in postgresql.conf.

listen_address='10.127.93.219'

I’ve also setup postgresql like below.

GRANT ALL ON schema public TO postgres;

But why is there this error

User `postgres` was denied access on the database `db.public`
2

When the error talks about a database, it’s a pure Postgres problem, has nothing to do with Docker.

Probably wrong user, pass or permissions granted on database access.