Cannot Connect (pg_hba.conf Error)

7926
1
04-15-2013 07:08 AM
ArthurMcDonough
New Contributor II
I am trying to follow the instructions on setting up the geoportal (open source) and have run into an issue connecting to my            postgresql database. I am getting "Error connecting to the server: FATAL: could not load pg_hba.conf" I have adjusted the pg_hba.conf by adding this (http://www.pgadmin.org/docs/1.8/hints/conn-hba.html) but it still is not working. Please help.
1 Reply
CliveReece
Esri Contributor
If the postgreSQL database is on the same machine as your web container running Geoportal Server, you might want to try:
# IPv4 local connections:
host    all             all             127.0.0.1/32            trust

(That's how mine is set up)

Still, it is probably worth double checking the following:
[ ] You can connect to your database using pgAdmin
[ ] The postgresql jdbc driver matches the version level of your postgreSQL database
[ ] The url value for the JNDI context file is pointing to the right postgreSQL database
Reply
0 Kudos