Change postgres password

gandalf · March 5, 2023, 8:37pm

I am new to openRemote an Docker. Therefore, I have been reasonably successful in installing and using OpenRemote based on the quickstart configuration.

In order to increase security, I would like to change the PostgreSQL password and port number. However, after making these changes, the Keycloak container does not start successfully. Could somebody tell me how to change the password and port or suggest where I can find some documentation about it?

Best regards.

Rich · March 6, 2023, 9:56am

Hi,

Security of postgres is only an issue if you expose the postgres DB port outside of the stack but if you want to change it see the profile/deploy.yml docker compose file which acts as a reference for all config options:

Specifically see the DB settings options for the manager service and the options for the postgres service.

If you are trying to do this for an existing DB then I don’t know if postgres service will update the user (you can refer to standard postgres docker image for assistance there as our image is based off of this).

github.com

openremote/openremote/blob/master/profile/deploy.yml#L205


      
          # Dump web server requests to logs; default: false
          OR_WEBSERVER_DUMP_REQUESTS: ${OR_WEBSERVER_DUMP_REQUESTS:-}
          
          
# Manager web server maximum worker thread count; default: Processor core count or 10
          OR_WEBSERVER_WORKER_THREADS_MAX: ${OR_WEBSERVER_WORKER_THREADS_MAX:-}
          
          
# Manager web server maximum IO thread count; default: Processor core count or 2
          OR_WEBSERVER_IO_THREADS_MAX: ${OR_WEBSERVER_IO_THREADS_MAX:-}
          
          
# Database settings
          OR_DB_VENDOR: ${OR_DB_VENDOR:-postgres}
          OR_DB_HOST: ${OR_DB_HOST:-postgresql}
          OR_DB_PORT: ${OR_DB_PORT:-5432}
          OR_DB_NAME: ${OR_DB_NAME:-openremote}
          OR_DB_SCHEMA: ${OR_DB_SCHEMA:-openremote}
          OR_DB_USER: ${OR_DB_USER:-postgres}
          OR_DB_PASSWORD: ${OR_DB_PASSWORD:-postgres}
          OR_DB_MIN_POOL_SIZE: ${OR_DB_MIN_POOL_SIZE:-5}
          OR_DB_MAX_POOL_SIZE: ${OR_DB_MAX_POOL_SIZE:-20}
          OR_DB_CONNECTION_TIMEOUT_SECONDS: ${OR_DB_CONNECTION_TIMEOUT_SECONDS:-300}

gandalf · March 6, 2023, 4:15pm

Thanks for your answer, Rich. I learned a bit more about docker-openremote with that.

Regards.