The PostgreSQL libraries do not honor the $HOME environment variable when looking for configuration files like .pgpass. This change amends the Dockerfile to mount the user's home directory in /root which conforms to the /etc/passwd entry for the root user. This allows sqitch to successfully locate .pgpass for credentials when connecting to db:pg: targets.
This could alternatively be solved by overriding or changing /etc/passwd to point to /home for the root user, but this approach seemed the least invasive.
theory
commented
5 years ago
The PostgreSQL libraries do not honor the
$HOMEenvironment variable when looking for configuration files like.pgpass. This change amends the Dockerfile to mount the user's home directory in/rootwhich conforms to the/etc/passwdentry for the root user. This allowssqitchto successfully locate.pgpassfor credentials when connecting todb:pg:targets.This could alternatively be solved by overriding or changing
/etc/passwdto point to/homefor the root user, but this approach seemed the least invasive.See Issue #2 for more information.