Escaping postgres password

Viewed 25

I need to escape my password in my pod. How can I do that? This password is being replaced with an environment variable, which is used on other platforms as well. So I can't replace it with the encoded version. Instead, I want to be able to encode it here somehow or do this escaping thing with bash scripting. Any ideas?

Unable to connect to the database at "postgresql://<username>:];,#]G),;@localhost:5432/database?sslmode=disable"

Password: ];,#]G),;

Encoded version: %5D%3B%2C%23%5DG)%2C%3B

How can we get this done without touching the environment variable?

To be more specific, I'm using postgres url in my Hashicorp boundary set up.

boundary database init -config /boundary/boundary-config.hcl

Config file (/boundary/boundary-config.hcl)

controller {
  name = "example-controller"
  description = "An example controller"
  database {
    url = "postgresql://<username>:<password>@10.0.0.1:5432/<database_name>"
    max_open_connections = 5
  }
}

https://www.boundaryproject.io/docs/oss/installing/postgres

0 Answers
Related