PostgreSQL JPA Hibernate persistence.xml

<persistence xmlns="http://xmlns.jcp.org/xml/ns/persistence"
             xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
             xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/persistence
             http://xmlns.jcp.org/xml/ns/persistence/persistence_2_1.xsd"
             version="2.1">

    <persistence-unit name="persistenceUnitName" transaction-type="RESOURCE_LOCAL">

        <properties>
            <property name="javax.persistence.jdbc.driver" value="org.postgresql.Driver" /> <!-- DB Driver -->
            <property name="javax.persistence.jdbc.url" value="jdbc:postgresql://localhost/dbName" /> <!-- BD Mane -->
            <property name="javax.persistence.jdbc.user" value="postgres" /> <!-- DB User -->
            <property name="javax.persistence.jdbc.password" value="12345" /> <!-- DB Password -->

	    <property name="hibernate.dialect" value="org.hibernate.dialect.PostgreSQLDialect"/> <!-- DB Dialect -->
            <property name="hibernate.hbm2ddl.auto" value="update" /> <!-- create / create-drop / update -->
            
            <property name="hibernate.show_sql" value="true" /> <!-- Show SQL in console -->
            <property name="hibernate.format_sql" value="true" /> <!-- Show SQL formatted -->
        </properties>

    </persistence-unit>

</persistence>

PostgreSQLDialect is deprecated, according to the docs.
You can use PostgreSQL95Dialect instead.

Well done! @SergioDiniz

THANKS

Wonderful bro !
You missed the port number on line 11 :
value="jdbc:postgresql://localhost:5432/dbName" -- This is the correct one with the default postgresql port number

Thanks, great job

Thanks!

Thanks!!!

Thanks!

Well done !

Thanks a lot!

thank you

What is the part <persistence-unit name=" ..." >
Should I insert there my project's name?

Thanks

@rodrigodiaslima1 you can insert anything, but when you use it, you need to use the same name in your project.

Thanks