You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I have setup spilo cluster and I am able to connect to it from within the container hosting the cluster.
I have a deployment file which hosts a nodejs application and tries to connect to the psql cluster.
When i exec into the nodejs container and run psql -h postgresql-cluster.default.svc.cluster.local -U postgres and enter password, I am able to connect to db. (postgresql-cluster.default.svc.cluster.local is the name of the CLusterIP service which exposes the psql cluster)
But when I try to connect to db from nodejs application using 'pg' npm module with same host, user and password, I get the following error
error: pg_hba.conf rejects connection for host "10.244.4.39", user "postgres", database "uptime", no encryption
Below is the content fro pg_hba.config file
cat pg_hba.conf
Do not edit this file manually!
It will be overwritten by Patroni!
local all all trust
hostssl all +zalandos 127.0.0.1/32 pam
host all all 127.0.0.1/32 md5
hostssl all +zalandos ::1/128 pam
host all all ::1/128 md5
local replication standby trust
hostssl replication standby all md5
hostnossl all all all reject
hostssl all +zalandos all pam
hostssl all all all md5
exit
Please guide me through
The text was updated successfully, but these errors were encountered:
I have setup spilo cluster and I am able to connect to it from within the container hosting the cluster.
I have a deployment file which hosts a nodejs application and tries to connect to the psql cluster.
When i exec into the nodejs container and run psql -h postgresql-cluster.default.svc.cluster.local -U postgres and enter password, I am able to connect to db. (postgresql-cluster.default.svc.cluster.local is the name of the CLusterIP service which exposes the psql cluster)
But when I try to connect to db from nodejs application using 'pg' npm module with same host, user and password, I get the following error
error: pg_hba.conf rejects connection for host "10.244.4.39", user "postgres", database "uptime", no encryption
Below is the content fro pg_hba.config file
cat pg_hba.conf
Do not edit this file manually!
It will be overwritten by Patroni!
local all all trust
hostssl all +zalandos 127.0.0.1/32 pam
host all all 127.0.0.1/32 md5
hostssl all +zalandos ::1/128 pam
host all all ::1/128 md5
local replication standby trust
hostssl replication standby all md5
hostnossl all all all reject
hostssl all +zalandos all pam
hostssl all all all md5
exit
Please guide me through
The text was updated successfully, but these errors were encountered: