Spring PostgreSQL Support

External

• https://dzone.com/articles/configuring-spring-boot-for-postgresql

Internal

• Spring Data

Dependencies

dependencies {

    implementation('org.springframework.boot:spring-boot-starter-data-jpa')
    runtimeOnly('org.postgresql:postgresql')
}

Spring Configuration

Add in application.properties or equivalent:

#spring.datasource.url=jdbc:postgresql://localhost:5432/postgres
#spring.datasource.username=playground
#spring.datasource.password=playground123
#spring.datasource.platform=postgres

spring.datasource.initialization-mode=always
spring.jpa.hibernate.ddl-auto=none
spring.jpa.show-sql=true

If using Spring Boot Database Initialization and Postgres-specific DDL and DML, create schema-postgres.sql, data-postgres.sql files and configure the "plaform" as:

spring.datasource.platform=postgres

More details available here:

Spring Boot Database Initialization