I am trying to add a PostGIS database a data store in my Geoserver installation but I keep getting this error:
Error creating data store, check the parameters. Error message: Unable to obtain connection: Cannot create PoolableConnectionFactory (Something unusual has occurred to cause the driver to fail. Please report this exception.)
I am thinking that maybe I need to add an entry to my
pg_hba.conf file, but it seems that adding anything to it causes the postgres server to not be able to start back up again.
Has anyone had this issue before? Was it solvable by addeding an entry to pg_hba.conf?
Since my geoserver resides on
http://localhost:8080/ I tried adding:
host all all 127.0.0.1/8080
pg_hba.conf but trying to restart the server just results in postgres crashing until I remove it again.
This is what the contents of my
pg_hba.conf look like:
# Database administrative login by Unix domain socket local all postgres peer # TYPE DATABASE USER ADDRESS METHOD # "local" is for Unix domain socket connections only local all all peer # IPv4 local connections: host all all 127.0.0.1/32 md5 # IPv6 local connections: host all all ::1/128 md5 # Allow replication connections from localhost, by a user with the # replication privilege. #local replication postgres peer #host replication postgres 127.0.0.1/32 md5 #host replication postgres ::1/128 md5
Here are the geoserver log outputs after I try to make the data store:
- geoserver version: 2.13
- Postgres version: 9.6.9
- PosGIS version: 2.4