PostgreSQL password does not work with $
PostgreSQL password (
gitlab_rails['db_password']) that contains
$ does not work.
$ gets interpolated as being empty and truncates the password.
Steps to reproduce
gitlab_rails['db_password']as something that contains
- Drop into geo database (
/opt/gitlab/bin/gitlab-geo-psql -d gitlabhq_geo_production)
- List user mappings (
\deu+). See that password has been truncated.
What is the current bug behavior?
$ is interpolated when used in PostgreSQL password.
What is the expected correct behavior?
$ should not be interpolated.
Relevant logs and/or screenshots
Exception: FATAL: password authentication failed for user "gitlab" FATAL: password authentication failed for user "gitlab"
Customer ticket: https://gitlab.zendesk.com/agent/tickets/102809 (internal use)