# Getting database connection error

**URL:** <https://forum.keycloak.org/t/getting-database-connection-error/23360>\
**Category:** Miscellanaeous\
**Created:** [November 15, 2023, 10:29am UTC](https://forum.keycloak.org/t/getting-database-connection-error/23360 "2023-11-15T10:29:17Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![raxa](https://avatars.discourse-cdn.com/v4/letter/r/b5ac83/32.png) [@raxa](https://forum.keycloak.org/u/raxa)\
**Post date:** [November 15, 2023, 10:29am UTC](https://forum.keycloak.org/t/getting-database-connection-error/23360/1 "2023-11-15T10:29:17Z")

</div>

I have shared a docker compose file below but we run docker compose we are getting below error.

[org.keycloak.quarkus.runtime.cli.ExecutionExceptionHandler] (main) ERROR: URL format error; must be “jdbc:h2:{ {.|mem:}[name] | [file:]fileName | {tcp|ssl}:[//]server[:port][,server2[:port]]/name }[;key=value…]” but is “jdbc:postgresql://postgres/keycloak” [90046-220]

Below I have share the docker-compose.yml file

version: ‘3’

services:  
keycloak:  
image: keycloak/keycloak  
command: start --optimized  
environment:  
- KEYCLOAK\_ADMIN=admin  
- KEYCLOAK\_ADMIN\_PASSWORD=admin  
- KC\_DB\_URL=jdbc:postgresql://postgres/keycloak  
- KC\_DB\_USER=keycloak  
- KC\_DB\_PASSWORD=keycloak  
- KC\_PROXY=edge  
- KC\_HOSTNAME\_STRICT=false  
- KC\_HTTPS\_CERTIFICATE\_FILE=/etc/letsencrypt/live/mydomain.net/fullchain.pem  
- KC\_HTTPS\_CERTIFICATE\_KEY\_FILE=/etc/letsencrypt/live/mydomain.net/privkey.pem  
- QUARKUS\_HTTP\_HOST=0.0.0.0  
- KC\_HOSTNAME\_URL=[https://mydomain.net/](https://mydomain.net/)  
ports:  
- “8484:8080”  
depends\_on:  
- keycloak-db

keycloak-db:  
image: postgres:latest  
environment:  
- POSTGRES\_DB=keycloak  
- POSTGRES\_USER=keycloak  
- POSTGRES\_PASSWORD=keycloak  
volumes:  
- pgdata\_keycloak:/var/lib/postgresql/data  
ports:  
- “5438:5432”  
volumes:  
pgdata\_keycloak:

---

<div class="post-metadata">

**Author:** ![sirishkumar](https://yyz2.discourse-cdn.com/free1/user_avatar/forum.keycloak.org/sirishkumar/32/6459_2.png) [@sirishkumar](https://forum.keycloak.org/u/sirishkumar)\
**Post date:** [November 22, 2023, 7:13pm UTC](https://forum.keycloak.org/t/getting-database-connection-error/23360/2 "2023-11-22T19:13:07Z")

</div>

Following parameters for DB works for me

```
  KC_DB: postgres
  KC_DB_USERNAME: keycloak
  KC_DB_PASSWORD: keycloak
  KC_DB_URL_HOST: postgres # service name in compose file

```

or refer below link for jdbc url format

> <https://github.com/keycloak/keycloak-benchmark/blob/main/provision/docker-compose/keycloak/keycloak-quarkus-postgres.yml>

---

<div class="post-metadata">

**Author:** ![gerdesj](https://yyz2.discourse-cdn.com/free1/user_avatar/forum.keycloak.org/gerdesj/32/9361_2.png) [@gerdesj](https://forum.keycloak.org/u/gerdesj)\
**Post date:** [December 1, 2023, 1:55pm UTC](https://forum.keycloak.org/t/getting-database-connection-error/23360/3 "2023-12-01T13:55:36Z")

</div>

Run it at least once without --optimized in the command line.