1

In Heroku, I have a PostgreSQL DB with all the credential to be accessed by outside (Host, Port, Database name, User, Password, URI). Then I connected pgAdmin with this database using the above credentials. Finally, I created a PostGIS extension for this database and I added a .shp file through the PostGIS Import/Export tool.

Now, I am trying to access this database as GeoServer Vector Data Source. When I enter all the db parameters (e.g Host, port and so on) in the "Connection Parameters" section I get an error:

Error creating data store, check the parameters. Error message: Unable to obtain connection: Cannot create PoolableConnectionFactory (FATAL: no pg_hba.conf entry for host "130.233.84.159", user "myuser", database "dbname", SSL off)

How can I solve this issue? Any hints?

Improve this question
3
  • 1
    See dba.stackexchange.com/questions/83984/…
    – TomazicM
    Oct 20, 2019 at 16:36
  • it doesn't work because actually I don't have the access to the pg_hba.config used by heroku postgresql...I mean: if I modify the one on my Pc of course nothing will happen
    – Teo
    Oct 20, 2019 at 17:23
  • Do you have a proxy on your network?
    – Stev_k
    Oct 21, 2019 at 8:24

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.