Boa tarde galerinha,

blza?!

pra quem deseja usar o banco Postgres invés do H2(que por sinal é muito bom pra estudos), segue aqui abaixo as configurações do applications.properties, junto com a dependência que também terá que ser adicionada no pom.xml.

===============================

= DATA SOURCE

===============================

Set here configurations for the database connection

spring.datasource.url=jdbc:postgresql://localhost:5432/forum spring.datasource.username=postgres spring.datasource.password=postgres spring.datasource.driver-class-name=org.postgresql.Driver

Keep the connection alive if idle for a long time (needed in production)

spring.datasource.testWhileIdle=true spring.datasource.validationQuery=SELECT 1

===============================

= JPA / HIBERNATE

===============================

Show or not log for each sql query

spring.jpa.show-sql=true

Hibernate ddl auto (create, create-drop, update): with "create-drop" the database

schema will be automatically created afresh for every start of application

spring.jpa.hibernate.ddl-auto=update

Naming strategy

spring.jpa.hibernate.naming.implicit-strategy=org.hibernate.boot.model.naming.ImplicitNamingStrategyLegacyHbmImpl spring.jpa.hibernate.naming.physical-strategy=org.springframework.boot.orm.jpa.hibernate.SpringPhysicalNamingStrategy

Allows Hibernate to generate SQL optimized for a particular DBMS

spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.PostgreSQLDialect

<dependency>
        <groupId>org.postgresql</groupId>
        <artifactId>postgresql</artifactId>
</dependency>