How can i save keycloak configuration with postgres in a docker-compose? #19962

brayanjeshua · 2023-04-26T08:41:10Z

brayanjeshua
Apr 26, 2023

Until now this is my compose i'm using keycloak in development but i want to use a new container as keycloak-db to store and persist the whole configuration of realms / users / groups ...

version: '3.3'

services:
  #   keycloak-db:
  #     image: postgres:13-alpine
  #     ports:
  #       - 5432
  #     logging:
  #       options:
  #         max-size: "10m"
  #         max-file: "3"
  #     volumes:
  #       - ./keycloak-db-data:/var/lib/postgresql/data
  #     environment:
  #       POSTGRES_USER: postgres
  #       POSTGRES_PASSWORD: postgres
  #       POSTGRES_DB: keycloak
  #     healthcheck:
  #       test: pg_isready || exit 1
  keycloak:
    image: quay.io/keycloak/keycloak:${KEYCLOAK_VERSION}
    restart: always
    env_file:
      - .env
    ports:
      - "${KEYCLOAK_PORT}:8080"
    command: start-dev
# networks:
#   app-tier:
#     driver: bridge
# volumes:
#   keycloak-db-data:

Answered by brayanjeshua

May 9, 2023

I solved it using the following parameters:

KC_APP_USERNAME=keycloak
KC_APP_PASSWORD=password
INIT_KC_ADMIN_USER=true
KC_DB=postgres
KC_DB_URL=jdbc:postgresql://keycloakdb/keycloak
KC_DB_PORT=5434
KC_DB_USERNAME=keycloak
KC_DB_PASSWORD=password
KC_HOSTNAME=localhost

In your case maybe add KC_HOSTNAME

View full answer

slominskir · 2023-05-09T14:02:18Z

slominskir
May 9, 2023

Here is an example docker compose project that configures Keycloak container to a database container:

https://github.com/slominskir/keycloak_oracle

The example uses Oracle database, but using Postgres will be very similar.

0 replies

souravs17031999 · 2023-05-09T14:17:59Z

souravs17031999
May 9, 2023

@brayanjeshua , check this below.

Btw, any exact issue/error are you facing ?

iam:
      image: quay.io/keycloak/keycloak:21.1.1
      environment:
        - KC_DB_URL=jdbc:postgresql://keycloak-db:5432/keycloak
        - KC_DB_USERNAME=postgres
        - KC_DB_PASSWORD=postgres
        - KEYCLOAK_ADMIN=admin
        - KEYCLOAK_ADMIN_PASSWORD=admin
      depends_on:
        - postgres

0 replies

brayanjeshua · 2023-05-09T14:35:46Z

brayanjeshua
May 9, 2023
Author

I solved it using the following parameters:

KC_APP_USERNAME=keycloak
KC_APP_PASSWORD=password
INIT_KC_ADMIN_USER=true
KC_DB=postgres
KC_DB_URL=jdbc:postgresql://keycloakdb/keycloak
KC_DB_PORT=5434
KC_DB_USERNAME=keycloak
KC_DB_PASSWORD=password
KC_HOSTNAME=localhost

In your case maybe add KC_HOSTNAME

0 replies

Navigation Menu

Repository navigation

How can i save keycloak configuration with postgres in a docker-compose? #19962

Uh oh!

{{title}}

Uh oh!

Replies: 3 comments

Uh oh!

{{title}}

Uh oh!

Uh oh!

{{title}}

Uh oh!

Uh oh!

{{editor}}'s edit

{{editor}}'s edit

Uh oh!

Uh oh!

{{title}}

Uh oh!

Uh oh!

{{editor}}'s edit

{{editor}}'s edit

Uh oh!

Select a reply

Uh oh!

How can i save keycloak configuration with postgres in a docker-compose? #19962

Uh oh!

brayanjeshua Apr 26, 2023

Replies: 3 comments

Uh oh!

slominskir May 9, 2023

Uh oh!

Uh oh!

souravs17031999 May 9, 2023

Uh oh!

Uh oh!

brayanjeshua May 9, 2023 Author

brayanjeshua
Apr 26, 2023

slominskir
May 9, 2023

souravs17031999
May 9, 2023

brayanjeshua
May 9, 2023
Author