I deploy Temporal server with username and password (K8s secret) at the deployment time. After deployment, the server is able to connect and create Postgres temporal databases.
Some time later, the Postgres user account automatically changes password. After this, Temporal server fails to connect Postgres databases.
Is there a way for Temporal server to refresh to password and re-connect to Postgres database?
Password is part of static config which gets generated on your service startup: https://github.com/temporalio/temporal/blob/main/docker/config_template.yaml#L139
Have seen users point to a db proxy rather than directly so can change the underlying db pass when needed. Otherwise if you need to change you would need to restart server to apply updates.