Ciao Roope, I would suggest to set up a JNDI datasource and then connect to it with a proper datastore.properties as explained here: http://geobatch.geo-solutions.it/download/latest/doc/actionImageMosaic.html#using-jndi-on-postgis
Regards, Simone Giannecchini == Our support, Your Success! Visit http://opensdi.geo-solutions.it for more information. == Ing. Simone Giannecchini @simogeo Founder/Director GeoSolutions S.A.S. Via Poggio alle Viti 1187 55054 Massarosa (LU) Italy phone: +39 0584 962313 fax: +39 0584 962313 mob: +39 333 8128928 http://www.geo-solutions.it http://twitter.com/geosolutions_it ------------------------------------------------------- On Wed, Sep 26, 2012 at 9:53 AM, Roope Tervo <roope.te...@fmi.fi> wrote: > Hello > > We have a setup with about 100 image mosaic data stores which all use > postgis database. At the moment every data store have maximum 5 > connections. Now we have a problem with too many connections to the > database. Does anyone have any experience, is it safe to decrease > connections to 1 per store or does it affect to the performance? > > best regards > Roope > > > ------------------------------------------------------------------------------ > Live Security Virtual Conference > Exclusive live event will cover all the ways today's security and > threat landscape has changed and how IT managers can respond. Discussions > will include endpoint security, mobile security and the latest in malware > threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ > _______________________________________________ > Geoserver-users mailing list > Geoserver-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/geoserver-users ------------------------------------------------------------------------------ Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://ad.doubleclick.net/clk;258768047;13503038;j? http://info.appdynamics.com/FreeJavaPerformanceDownload.html _______________________________________________ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
