masayag opened a new issue, #3138: URL: https://github.com/apache/incubator-kie-tools/issues/3138
When running workflow using the devmode image, an embedded PostgreSQL server is started by `zonky` However, there is no option to access that database in that mode. For example, when starting the devmode with setting `quarkus.embedded.postgresql.port=5432` and exposing the port `-p 5432:5432` in the command below (to prevent a random port as explained [here](https://github.com/quarkiverse/quarkus-embedded-postgresql): ``` podman run --rm --name backstage-internal-sonataflow \ -e QUARKUS_HTTP_PORT=8080 -p 8080:8080 \ -p 5432:5432 \ -e KOGITO_SERVICE_URL=http://localhost:8080/ \ -e QUARKUS_EMBEDDED_POSTGRESQL_DATA_DIR=/home/kogito/persistence \ -e MAVEN_ARGS_APPEND="-Dquarkus.embedded.postgresql.port=5432" \ quay.io/kubesmarts/incubator-kie-sonataflow-devmode:9.103.x-prod ``` Even with that, an access to PostgreSQL will not be allowed since internally postgresql is configured by `zonky` with: 1. `#listen_addresses = 'localhost' # what IP address(es) to listen on;` in postgresql.conf 2. In hba.conf with ``` host all all 127.0.0.1/32 trust host all all ::1/128 trust ``` meaning, zonky does not support connection from outside. In addition, the fact `pdql` cli isn't packaged in the image makes it impossible to get to the postgresql DB. By adding a dashboard extension to enable access to the DB, we can spare a more complex configuration in which we use an external PostgreSQL server for development. Somehow related to https://github.com/apache/incubator-kie-tools/issues/3137 p.s. even without the extension, changes to the image will be welcomed to support an access to the embedded pgsql. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
