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 "", user "myuser", database "dbname", SSL off)

How can I solve this issue? Any hints?

  • 1
  • 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 '19 at 17:23
  • Do you have a proxy on your network? – Stev_k Oct 21 '19 at 8:24

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.