I can't get a connection up when creating a PostGIS-store.
- GeoServer is running fine on IP:80/GeoServer.
- PostGIS is running and working fine with PSQL commands
- Created database/table 'mydb' and 'mytable' then changed ownership to Postgres
Error creating data store, check the parameters. Error message: Unable to obtain connection: Cannot create PoolableConnectionFactory (FATAL: no pg_hba.conf entry for host "127.0.0.1", user "postgres", database "main", SSL off)
PG_HBA.CONF # Database administrative login by Unix domain socket #local all postgres peer local all postgres trust # 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 host all all 188.8.131.52/16 md5 host all all 184.108.40.206/16 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
Any idea what is going wrong?
I'm on a Ubuntu on AWS-EC2.