George Cheng's Profile

So I discovered an odd problem with using Capistrano::CLI.password_prompt "PostgreSQL Password: "

I spent most of the day trying to figure out why I was getting this error
FATAL: password authentication failed for user "DBuser"
at the bundle exec rake RAILS_ENV=production db:migrate
stage of my cap deploy:cold.

Turns out that when I use special characters when prompted for the db user password during
cap deploy:setup, the cold deploy fails. But if I use a password without any special characters then the cold deploy works.

I don't know why this would be the case, so if anyone has any ideas as to why special characters can't be used, I'd love to be enlightened.