Skip to content

Instantly share code, notes, and snippets.

@ytbryan
Created April 19, 2015 10:19
Show Gist options
  • Select an option

  • Save ytbryan/4c4db2f12f2a06b698df to your computer and use it in GitHub Desktop.

Select an option

Save ytbryan/4c4db2f12f2a06b698df to your computer and use it in GitHub Desktop.
fixing PG::ConnectionBad: FATAL: password authentication failed for user "postgres"
#go to hb_hba.conf
local all postgres ident
#go to psql
sudo -u postgres psql
#enter the following command to set or change the password
ALTER USER postgres PASSWORD 'actual_password';
#go to hb_hba.conf to change this line back
local all postgres md5
#try to rake db:create or migrate again
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment