Files
config-repo/user-service-prod.yml
2025-09-17 11:02:24 +09:00

55 lines
1.7 KiB
YAML

db:
hostname: 192.168.0.102
database:
url: jdbc:postgresql://${db.hostname:localhost}:5432/CS0227?currentSchema=sm_bs_cs
spring:
datasource:
url: jdbc:postgresql://${db.hostname:localhost}:5432/CS0227?currentSchema=sm_bs_cs
username: msaportal
password: msaportal
driver-class-name: org.postgresql.Driver
hikari:
minimum-idle: 5 # 너무 많은 유휴 연결 방지
maximum-pool-size: 20 # DB 부하와 병목 최소화
idle-timeout: 30000 # 30초 후 유휴 연결 제거
max-lifetime: 1800000 # 30분 후 커넥션 재생성
connection-timeout: 5000 # 커넥션 요청 타임아웃 (5초)
data-source-properties:
cachePrepStmts: true
prepStmtCacheSize: 512
prepStmtCacheSqlLimit: 4096
useServerPrepStmts: true
jpa:
database-platform: org.hibernate.dialect.PostgreSQLDialect
open-in-view: false
generate-ddl: true
hibernate:
ddl-auto: none
properties:
hibernate:
format_sql: true
default_batch_fetch_size: 1000
jdbc:
lob:
non_contextual_creation: true
show-sql: true
defer-datasource-initialization: true
sql:
init:
mode: always
platform: postgresql
mail: # 비밀번호 변경 이메일 발송
host: smtp.gmail.com # smtp host
port: 587 # smtp port
username: email_username # 계정
password: 'email_password_0704' # 비밀번호 - 구글 보안 2단계 인증 해제, 보안 수준이 낮은 앱의 액세스 허용(https://myaccount.google.com/lesssecureapps)
properties:
mail:
smtp:
auth: true
starttls:
enable: true
required: true