Home:ALL Converter>PyCharm error when connecting to PostgreSQL database

PyCharm error when connecting to PostgreSQL database

Ask Time:2018-08-01T02:29:42         Author:Babken Vardanyan

Json Formatter

I'm getting this error when trying to connect to a PostgreSQL 9.4 database running on Heroku/AWS:

The specified database user/password combination is rejected:
[28000] FATAL: no pg_hba.conf entry for host "X.X.X.X", user "XXX", database "XXX"

How do I solve this issue?

Author:Babken Vardanyan,eproduced under the CC 4.0 BY-SA copyright license with a link to the original source and this disclaimer.
Link to original article:https://stackoverflow.com/questions/51619880/pycharm-error-when-connecting-to-postgresql-database
Babken Vardanyan :

Open the database connection settings, click on the \"Advanced\" tab and values to the following parameters:\n\nssl = false\n\nsslfactory = org.postgresql.ssl.NonValidatingFactory\n\nClick Apply and Test Connection.\n\nCredits: https://intellij-support.jetbrains.com/hc/en-us/community/posts/205996299/comments/206373089",
2018-07-31T18:29:42
yy