topic Cannot Connect (pg_hba.conf Error) in Esri Geoportal Server Questions https://community.esri.com/t5/esri-geoportal-server-questions/cannot-connect-pg-hba-conf-error/m-p/644738#M764 <HTML><HEAD></HEAD><BODY><SPAN>I am trying to follow the instructions on setting up the geoportal (open source) and have run into an issue connecting to my&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 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 (</SPAN><A href="http://www.pgadmin.org/docs/1.8/hints/conn-hba.html">http://www.pgadmin.org/docs/1.8/hints/conn-hba.html</A><SPAN>) but it still is not working. Please help.</SPAN></BODY></HTML> Mon, 15 Apr 2013 14:08:10 GMT ArthurMcDonough 2013-04-15T14:08:10Z Cannot Connect (pg_hba.conf Error) https://community.esri.com/t5/esri-geoportal-server-questions/cannot-connect-pg-hba-conf-error/m-p/644738#M764 <HTML><HEAD></HEAD><BODY><SPAN>I am trying to follow the instructions on setting up the geoportal (open source) and have run into an issue connecting to my&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 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 (</SPAN><A href="http://www.pgadmin.org/docs/1.8/hints/conn-hba.html">http://www.pgadmin.org/docs/1.8/hints/conn-hba.html</A><SPAN>) but it still is not working. Please help.</SPAN></BODY></HTML> Mon, 15 Apr 2013 14:08:10 GMT https://community.esri.com/t5/esri-geoportal-server-questions/cannot-connect-pg-hba-conf-error/m-p/644738#M764 ArthurMcDonough 2013-04-15T14:08:10Z Re: Cannot Connect (pg_hba.conf Error) https://community.esri.com/t5/esri-geoportal-server-questions/cannot-connect-pg-hba-conf-error/m-p/644739#M765 <HTML><HEAD></HEAD><BODY><SPAN>If the postgreSQL database is on the same machine as your web container running Geoportal Server, you might want to try:</SPAN><BR /><SPAN># IPv4 local connections:</SPAN><BR /><SPAN>host&nbsp;&nbsp;&nbsp; all&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; all&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 127.0.0.1/32&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; trust</SPAN><BR /><BR /><SPAN>(That's how mine is set up)</SPAN><BR /><BR /><SPAN>Still, it is probably worth double checking the following:</SPAN><BR /><SPAN>[ ] You can connect to your database using pgAdmin</SPAN><BR /><SPAN>[ ] The postgresql jdbc driver matches the version level of your postgreSQL database</SPAN><BR /><SPAN>[ ] The url value for the JNDI context file is pointing to the right postgreSQL database</SPAN></BODY></HTML> Tue, 16 Apr 2013 12:48:15 GMT https://community.esri.com/t5/esri-geoportal-server-questions/cannot-connect-pg-hba-conf-error/m-p/644739#M765 CliveReece 2013-04-16T12:48:15Z