Hi, We have 50 postgis stores in our geoserver, all set with the default parameters.
Now, to avoid having to change IP address of postgresql databases in all the datastore.xml files (currently done with python, when deploying the data directory from dev to staging or production (different environments, different databases), we think to adopt a different strategy: To define once and for all a postgresql resource (named jdbc/databrugis) in a context.xml file, and pass all the 50 stores from postgis type to postgis (JNDI) type using that resource (java:comp/env/jdbc/databrugis). My question is this: Does this will provoke a bottleneck? Having 50 stores using the same resource? Should I change some resource parameters, for instance maxActive, from 20 to let's say maybe not 20*50 but a bigger number? And will this be without effect on the DB slots usage, to have it connected from one resource only instead of 50 different stores? Thank you already for your expert insight on this đŸ™‚. Greg
_______________________________________________ Geoserver-users mailing list Please make sure you read the following two resources before posting to this list: - Earning your support instead of buying it, but Ian Turton: http://www.ianturton.com/talks/foss4g.html#/ - The GeoServer user list posting guidelines: http://geoserver.org/comm/userlist-guidelines.html If you want to request a feature or an improvement, also see this: https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
