Hi, im trying to create a postgres

Hi, im trying to create a postgres resource managed by aws, with ssl disabled. I already created a user and whitelisted the workers IPs but when i test the connection a get "FATAL: no pg_hba.conf entry for host". I tested the same setup using dbeaver and didn't have any problem. How can i fix this? thanks in advance
6 Replies
Sindre
Sindre2y ago
are you trying deno, node, python or posgres native script? or something else?
matiasbpg_25163
matiasbpg_25163OP2y ago
i want a postgres native script, but got blocket testing the resouce
rubenf
rubenf2y ago
this error is that the combo user+password+ssl+origin is not whitelisted by the DB
matiasbpg_25163
matiasbpg_25163OP2y ago
i understand ill look into the whitelisting with my administrator. This makes me wonder how come dbeaver doesn't have this problem. thank you just changing the ssl_mode to required worked, i don't get why, but at least it worked hahah
rubenf
rubenf2y ago
that's part of the whitelisting rules of your DB
matiasbpg_25163
matiasbpg_25163OP2y ago
thanks for your time!

Did you find this page helpful?