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
  cloud:
    stream:
      bindings:
        attachmentEntity-out-0: # 첨부파일 entity 정보 업데이트 하기 위한 이벤트
          destination: attachment-entity.topic # queue name
          group: attachment
        hardDeleteEntity-out-0: # 첨부파일 entity 정보 물리 삭제 하기 위한 이벤트
          destination: hard-delete-entity.topic # queue name
          group: attachment
  jpa:
    database-platform: org.hibernate.dialect.PostgreSQLDialect
    generate-ddl: true
    hibernate:
      ddl-auto: none
    properties:
      hibernate:
        dialect: org.hibernate.dialect.PostgreSQLDialect
        format_sql: true
        globally_quoted_identifiers: false
        default_batch_fetch_size: 1000
    open-in-view: false
    show-sql: true
    defer-datasource-initialization: true
  sql:
    init:
      mode: always
      platform: postgresql