How to use yaml config alongside with environment variables?

[spongenee]

Maybe I missed this in the docs. Is there a way I could use yaml config along side with environment variables for pgstream run or pgstream snapshot commands? For obvious reasons too, I don't want any password inside the configuration file.

I tried the following and I get the error Error: error setting up postgres replication handler: create postgres replication client: failed to connect to user=ubuntu database=: /tmp/.s.PGSQL.5432 (/tmp): dial error: dial unix /tmp/.s.PGSQL.5432: connect: no such file or directory. Once I add source and target urls to config.yaml, the command runs.

PGSTREAM_POSTGRES_LISTENER_URL=$PGSTREAM_POSTGRES_LISTENER_URL \ PGSTREAM_POSTGRES_WRITER_TARGET_URL=$PGSTREAM_POSTGRES_WRITER_TARGET_URL \ ./pgstream.dev snapshot -c config.yml

[eminano]

Hi @spongenee !

Currently the environment and the yaml configurations can't be used together, it's either one or the other. We have an issue open to add support for referencing environment variables within the yaml configuration file to prevent exposing sensitive data:

You can use the workaround suggested by skeggr in order to get it working for now 🙏

Thank you! 💟