<html><head></head><body><div style="color:#000; background-color:#fff; font-family:Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:13px"><div id="yui_3_16_0_ym19_1_1513074091671_4572">Hello,</div><div id="yui_3_16_0_ym19_1_1513074091671_4710"><br></div><div dir="ltr" id="yui_3_16_0_ym19_1_1513074091671_4919">I would like to use GeoFence with PostgreSQL instead of H2 database which is the default one. I have been following the steps from here: <a href="https://github.com/geosolutions-it/geofence/wiki/GeoFence-configuration" class="" id="yui_3_16_0_ym19_1_1513074091671_4934">https://github.com/geosolutions-it/geofence/wiki/GeoFence-configuration</a></div><div dir="ltr" id="yui_3_16_0_ym19_1_1513074091671_4754">As far as I understood I don't really have to install anything, just replace the H2 hibernate dialect of H2 with the PostgreSQL one. After this create an overwrite file that should tell GeoFence to use the PostgreSQL hibernate dialect instead of H2, and should look like this: <a href="https://github.com/geosolutions-it/geofence/blob/master/src/gui/web/src/main/resources/geofence-datasource-ovr.properties.sample" id="yui_3_16_0_ym19_1_1513074091671_5011">https://github.com/geosolutions-it/geofence/blob/master/src/gui/web/src/main/resources/geofence-datasource-ovr.properties.sample</a> (ofcourse I uncommeted the lines specified in the first link)<br></div><div dir="ltr" id="yui_3_16_0_ym19_1_1513074091671_5134">The file is located in the conf folder of Tomcat installation and in the setenv file from the bin folder inside Tomcat is pointing to this file. <br></div><div dir="ltr" id="yui_3_16_0_ym19_1_1513074091671_5117"><br></div><div dir="ltr" id="yui_3_16_0_ym19_1_1513074091671_5108">The thing is when I remove the the H2 hibernate file (hibernate-spatial-h2-geodb-1.1.1.jar) from Web-Inf/lib and add the PostgreSQL hibernate file (hibernate-spatial-postgis-1.1.1.jar), GeoServer stops and it is impossible to turn it on, unless I add the H2 hibernate file again.</div><div dir="ltr" id="yui_3_16_0_ym19_1_1513074091671_5295"><br></div><div dir="ltr" id="yui_3_16_0_ym19_1_1513074091671_5231">Is it something that I'm missing or I should install a stand alone version of GeoFence?</div><div dir="ltr" id="yui_3_16_0_ym19_1_1513074091671_5309"><br></div><div dir="ltr" id="yui_3_16_0_ym19_1_1513074091671_5336">Thanks,</div><div dir="ltr" id="yui_3_16_0_ym19_1_1513074091671_5337">Corina<br></div><div id="yui_3_16_0_ym19_1_1513074091671_4852"><br></div><div id="yui_3_16_0_ym19_1_1513074091671_4993"><br></div><div dir="ltr" id="yui_3_16_0_ym19_1_1513074091671_4719"><br></div></div></body></html>