Using Docker and PostgreSQL: How can I set administrator password in official postgresql image? (But securely, not a living environment variable)

[kopax]

I am using the official PostgreSQL Docker imnage (postgresql:11-alpine) from Docker HUB registry.

I want to create the PostgreSQL administrator password in a safe way.

Currently, this image offer to set it using environment variable:

Using environment variables is not really safe as it can be seen after initialization by anyone having access to the host.

There is another option for setting the password but that only work in docker swarm.

In this image, how can I set the PostgreSQL administrator, securely, and without manual step during initial deployment?Using Docker and PostgreSQL: How can I set administrator password in official postgresql image? (But securely, not a living environment variable)

[tianon]

See further down, under "Docker Secrets" (https://hub.docker.com/_/postgres#docker-secrets):

As an alternative to passing sensitive information via environment variables, _FILE may be appended to some of the previously listed environment variables, causing the initialization script to load the values for those variables from files present in the container.

The added functionality to support Docker Swarm's "secrets" feature is fully generic and usable without a "real" container orchestration system at all.

So what you're looking for is POSTGRES_PASSWORD_FILE with a file provided by your orchestration system (and then later removed).

In the future, these sorts of questions/requests would be more appropriately posted to the Docker Community Forums, the Docker Community Slack, or Stack Overflow.