Are they all connecting to the same database? If so you may consider setting up the database connection pool once in tomcat, and then setting up each datastore to use this connection pool (by using a JNDI reference to the connection pool in tomcat). -- Jody Garnett
On Tue, 3 Sep 2019 at 20:15, Pablo J. Zader <pza...@gmail.com> wrote: > Hi list > > I have approximately 160 layers stored in postgis. The layers was loaded > automatically using the geoserver api rest. Recurrently postgres runs out > of available connections. (FATAL: remaining connection slots are reserved > for non-replication superuser connections) . > Reviewing the data stores, I found that none of the parameters are set. > According to the geoserver documentation [1], it is indicated that they > must be configured for each data store. The question is: is there any way > to configure the parameters in bulk, using the api rest of geoserver? since > doing it one by one is a tedious task. > > Regards > Pablo > > [1] > https://docs.geoserver.org/stable/en/user/data/database/connection-pooling.html > -- > > Pablo J. Zader > Lic. en Cs. de la Computación + MSc. en Aplicaciones Espaciales de Alerta > y Respuesta Temprana a Emergencias > pablo.za...@gmail.com > > Universidad Nacional de Córdoba > Av. Valpáraíso s/n Ciudad Universitaria > [image: skype] [image: linkedIn] > <http://linkedin.com/in/pablo-javier-zader-7a232125> > > *"Los Grandes Hombres hablan sobre ideas... Los Hombres Promedio hablan > sobre cosas... Los Hombres Pequeños hablan.. de otros Hombres.* > > *del libro Matemática estas ahí? A. Paenza "* > > _______________________________________________ > 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 >
_______________________________________________ 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
