Connection to Postgres fails for passwords containing hashtags #

[jackrsteiner]

When attempting to connect to a PostgreSQL 13.4 instance, I found passwords containing the # character would result in failure:

getaddrinfo EAI_AGAIN postgres postgres:5432

Worth noting, this instance isn't at port 5432, so a bit of an odd error message.

A post on stackexchange claims that the node-postgres package doesn't accept passwords containing hashtags. The recommendation is to encode passwords using encodeURIComponent. For example:

const userPasswordDatabase = ${encodeURIComponent(database.dbPassword)}@;