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=something
spring.datasource.password=somethingelse

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