<aside> 💡

DB

Server

AWS

AOLDA

</aside>

DB

psql ajouchong -U chongchong

CREATE ROLE chongchong WITH LOGIN PASSWORD 'chongchong' ALTER ROLE chongchong CREATEDB; ALTER ROLE chongchong CREATEROLE; GRANT ALL PRIVIELEGES ON DATABASE ajouchong TO chongchong;

postgreSQL 버전 14.12

sudo docker exec -it ajouchong-db psql -U chongchong -d ajouchong

TRUNCATE TABLE admin, agora, agora_like, answer, event, intro_post, member, 
notice_like, notice_post, notice_post_images, partner_images, partnership, 
qna_like, qna_post, rule_post RESTART IDENTITY CASCADE;

TRUNCATE TABLE notice_like, notice_post, notice_post_images, partner_images, partnership RESTART IDENTITY CASCADE;

Server

spring:
  datasource:
    url: ${SPRING_DATASOURCE_URL}
    username: ${SPRING_DATASOURCE_USERNAME}
    password: ${SPRING_DATASOURCE_PASSWORD}

secret: ${JWT_SECRET}

→ application-prod.yml

spring:
  application:
    name: ajouchong
  config:
    import: optional:file:./.env
  datasource:
    driver-class-name: org.postgresql.Driver
    url: ${SPRING_DATASOURCE_URL}
    username: ${SPRING_DATASOURCE_USERNAME}
    password: ${SPRING_DATASOURCE_PASSWORD}
  profiles:
    active: prod
    include: oauth
  jpa:
    show-sql: true
    database: postgresql
    hibernate:
      ddl-auto: update
    properties:
      hibernate:
        show_sql: true
    open-in-view: false
  sql:
    init:
      mode: always
  spring:
    servlet:
      multipart:
        max-file-size: 10MB
        max-request-size: 10MB
  jackson:
    time-zone: Asia/Seoul

jwt:
  secret: ${JWT_SECRET}

server:
  port: 8080

cloud:
  aws:
    s3:
      bucket: ${BUCKET_NAME}
    stack.auto: false
    region.static: ap-northeast-2
    credentials:
      access-key: ${ACCESS_KEY}
      secret-key: ${SECRET_KEY}

spring:
  security:
    oauth2:
      client:
        registration:
          google:
            client-id: ${CLIENT_ID}
            client-secret: ${CLIENT_SECRET}
            scope: profile, email