KprWarnAnalyCore/sql.properties

spring.datasource.data.jdbc-url=jdbc:postgresql://140.246.183.164:5432/water_smart_develop_branch?useSSL=false&useAffectedRows=false&allowMultiQueries=true
#spring.datasource.data.jdbc-url=jdbc:postgresql://10.101.3.104:5432/watersmart_new?useSSL=false&useAffectedRows=false&allowMultiQueries=true
spring.datasource.data.username=postgres
spring.datasource.data.password=kpr.23417.postgres

#spring.datasource.data.jdbc-url=jdbc:postgresql://192.168.0.4:5432/watersmart?useSSL=false&useAffectedRows=false&allowMultiQueries=true
#spring.datasource.data.username=postgres
#spring.datasource.data.password=kpr.23417.postgres


spring.datasource.data.driver-class-name=org.postgresql.Driver

spring.datasource.data.max-wait=60000
spring.datasource.data.maximum-pool-size=200
spring.datasource.data.minimum-idle=1
spring.datasource.data.validation-query=SELECT 1
spring.datasource.data.connection-test-query=SELECT 1
spring.datasource.data.test-on-borrow=false
spring.datasource.data.test-on-return=false
spring.datasource.data.test-while-idle=true
spring.datasource.data.max-lifetime=120000
spring.datasource.data.idle-timeout=30000
spring.datasource.data.connection-timeout=30000
# 配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位是毫秒
spring.datasource.data.time-between-eviction-runs-millis=60000
# 配置一个连接在池中最小生存的时间，单位是毫秒
spring.datasource.data.minEvictableIdleTimeMillis=300000