PostgreSQL password in config file

[cloudmaster39]

Hello!

Thank you very much for such an amazing program!

Could you please help me with the following question?

I am running Temporal using systemctl with a connection to PostgreSQL. I have configured everything according to the documentation, and it works perfectly!

However, I have one concern. I really don’t like storing the database password in the configuration YAML file.
How can I configure Temporal, when running it via a systemd unit, so that it retrieves the PostgreSQL password from an environment variable? I’ve tried all possible options but haven’t had any success so far.

I would greatly appreciate your help. Thank you!

[yiminc]

@cloudmaster39, please see discussion here: https://community.temporal.io/t/temporal-with-custom-postgres-db/4787/3

[cloudmaster39]

@cloudmaster39, please see discussion here: https://community.temporal.io/t/temporal-with-custom-postgres-db/4787/3

Thank you very much for the quick reply, but my question is not answered there. I have studied all the documentation and have not found the answer.

I'm interested in how to specify the password value from the environment variable in a configuration file like this one

/etc/temporal/temporal-server.yaml

log:
stdout: true
level: info

persistence:
defaultStore: postgres-default
visibilityStore: postgres-visibility
numHistoryShards: 4
datastores:
postgres-default:
sql:
pluginName: "postgres12"
connectAddr: "127.0.0.1:5432"
connectProtocol: "tcp"
databaseName: "temporal"
user: "user_temporal"
password: "password_temporal"