PostgreSQL Integration

Hi all, do we have a guideline available to integrate PostgreSQL into camunda application. I’m using the project template from start.camunda.com. I don’t want to use the default H2 database in my application. Would appreciate a blog/guideline/best Practice/ video.

Thanks in Advance,
Ali

@hello.aliasad,

Add this dependency to the classpath:

<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-jdbc</artifactId>
    <version>2.2.1.RELEASE</version>
</dependency>

And refer this post for datasources configuration:

2 Likes

@aravindhrs thanks for the solution. Just one quick question, where do we get url value from? Will given url value works fine?
spring.datasource.url=jdbc:postgresql://localhost:5432/camunda

@hello.aliasad if you install the postgres database in your local machine with same port, then the url work fine. And schema you need to create it, empty schema is enough, engine will auto create the tables for you. You need to enable autoschema update as true.

1 Like

Thank you so much, really apprciate it. With postgreSQL integration do we need to include the H2 database dependency in the pom.xml file or we can remove that dependency?

@hello.aliasad h2 is not required. you can remove it

1 Like

appreciate it. Thanks :slight_smile: