Hi Thank for you help It worked to postgres database
Geoserver 2.15 Tomcat 9 Ubuntu 18.04 LST Driver: https://jdbc.postgresql.org/download/postgresql-42.2.6.jar cp postgresql-42.2.6.jar tomcat/lib <Resource name="jdbc/postgres" auth="Container" type="javax.sql.DataSource" driverClassName="org.postgresql.Driver" url="jdbc:postgresql://IP_DB:PORT_DB/NAME_DB" username="USER_DB" password="PASS_DB" maxTotal="5" initialSize="0" minIdle="0" maxIdle="8" maxWaitMillis="10000" timeBetweenEvictionRunsMillis="30000" minEvictableIdleTimeMillis="60000" testWhileIdle="true" validationQuery="SELECT 1" maxAge="600000" rollbackOnReturn="true" /> Regards Pablo El mié., 4 sept. 2019 a las 1:31, Humphries, Graham (< graham.humphr...@stategrowth.tas.gov.au>) escribió: > I have found it convenient to configure the datastores as JNDI datasources > that are defined in the Tomcat configuration. This enables using connection > pooling enabled at the application server level. > > > > It is also much easier to move data between environments as you can > configure the datasources in each environment using the same names so the > datastores work with no extra configuration. > > > > In Tomcat the datasources can be configured in > <TOMCAT_HOME>/conf/context.xml like this (for Oracle): > > > > <Resources cachingAllowed="true" cacheMaxSize="100000" /> > > > > <Resource name="jdbc/brm" > > auth="Container" > > type="javax.sql.DataSource" > > url="jdbc:oracle:thin:@<servername>:<port_no>/<servicename>" > > driverClassName="oracle.jdbc.OracleDriver" > > username="<username>" > > password="<password>" > > initialSize="10" > > maxTotal="100" > > maxWaitMillis="20000" > > validationQuery="SELECT SYSDATE FROM DUAL" /> > > </Resources> > > > > Cheers, > > > > Graham H. > > > > *From:* Pablo J. Zader [mailto:pza...@gmail.com] > *Sent:* Wednesday, 4 September 2019 1:13 PM > *To:* geoserver-users <geoserver-users@lists.sourceforge.net> > *Subject:* [Geoserver-users] Set database conecctiones polling > > > > 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: Image removed by sender. skype] [image: Image removed by sender. > 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 "* > > > ------------------------------ > > > CONFIDENTIALITY NOTICE AND DISCLAIMER > The information in this transmission may be confidential and/or protected > by legal professional privilege, and is intended only for the person or > persons to whom it is addressed. If you are not such a person, you are > warned that any disclosure, copying or dissemination of the information is > unauthorised. If you have received the transmission in error, please > immediately contact this office by telephone, fax or email, to inform us of > the error and to enable arrangements to be made for the destruction of the > transmission, or its return at our cost. No liability is accepted for any > unauthorised use of the information contained in this transmission. > > ------------------------------ > > CONFIDENTIALITY NOTICE AND DISCLAIMER > The information in this transmission may be confidential and/or protected > by legal professional privilege, and is intended only for the person or > persons to whom it is addressed. If you are not such a person, you are > warned that any disclosure, copying or dissemination of the information is > unauthorised. If you have received the transmission in error, please > immediately contact this office by telephone, fax or email, to inform us of > the error and to enable arrangements to be made for the destruction of the > transmission, or its return at our cost. No liability is accepted for any > unauthorised use of the information contained in this transmission. > -- 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
