Camunda Postgresql DataSource Configuration

Camunda 7 Topics Discussion & Questions
1

When i try to persist Camunda tables into Postgresql DB. I gave specific schema name (camunda) for creation but Camunda engine persist tables under Psql public schema.

Can anyone help for this how can I persist camunda to specific Schema under Postgre DB.

Here is the my application.yaml file

server:
    port: 10101
    servlet:
        context-path: /camunda

    datasource:
        username: ${DB_USERNAME:postgres}
        password: ${DB_PASSWORD:postgres}
        url: jdbc:postgresql://${DB_HOST:localhost}:${DB_PORT:5432}/${DB_NAME:postgres}

    jpa:
        database-platform: org.hibernate.dialect.PostgreSQLDialect
        hibernate:
            ddl-auto: ${DDL_AUTO:update}
        properties:
            hibernate:
                default_schema: ${DB_SCHEMA_NAME:camunda}
                dialect: org.hibernate.dialect.PostgreSQLDialect

camunda:
    bpm:
        admin-user:
            id: demo
            password: demo
        schema-name: camunda
        table-prefix: camunda.
        schema-update: true
        database:
            type: postgres
        jpa:
            enabled: true
2

hello,
Try to put the shema name in the jdbc url jdbc:postgresql://${DB_HOST:localhost}:${DB_PORT:5432}/${DB_NAME:postgres}?currentSchema=camunda

3

Hi @yusuf_tansu could you please tell me how to configure postgresql with camunda with out using eclipse or pok.xml . By using default.yaml or production.yaml in the Camunda installation how to configure psql with camunda …when I do changes in default.yaml like replacing h2 with postgres SQL and username and password I have declared psql details and jdbc url as jdbc://localhost:5432/database name?searchpath:myschema
When I am doing this I am not able to run atleast my Camunda engine could any one please help

4