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`