PostgreSQL spring boot config 및 db 생성

박진은·2023년 12월 16일
0

Projects

목록 보기
3/4

tasks
#toyProject

tasks

  • postgreSQL user 생성 및 spring boot 연동 🛫 2023-12-02 📅 2023-12-02 ✅ 2023-12-02
## database  
spring.datasource.driver-class-name=org.postgresql.Driver  
spring.datasource.url=jdbc:postgresql://xxx.xxx.xxx.xxx:5432/playground  
spring.datasource.username=admin  
spring.datasource.password=*** 
  
## jpa  
spring.jpa.show-sql=true  
spring.jpa.hibernate.ddl-auto=create  
spring.jpa.properties.hibernate.format_sql=true  
spring.jpa.properties.hibernate.jdbc.lob.non_contextual_creation=true  
  
## logging  
logging.level.org.hibernate.sql=debug  
logging.level.org.hibernate.type.descriptor.sql.spi=trace

유저 생성

psql (14.10)
Type "help" for help.

yum_map_db=# CREATE USER jineun_park PASSWORD 'hjkas1541' SUPERUSER;
CREATE ROLE
profile
코딩

0개의 댓글