Rails: FATAL – Peer authentication failed for user (PG::Error)

by

If you installed postresql on your server then just host: localhost to database.yml, I usually throw it in around where it says pool: 5. Otherwise if it’s not localhost definitely tell that app where to find its database. 

development:
  adapter: postgresql
  encoding: unicode
  database: kickrstack_development
  host: localhost
  pool: 5
  username: kickrstack
  password: secret

Make sure your user credentials are set correctly by creating a database and assigning ownership to your app’s user to establish the connection. To create a new user in postgresql 9 run:

sudo -u postgres psql

set the postgresql user password if you haven’t, it’s just backslash password.

postgres=# \password

Create a new user and password and the user’s new database:

postgres=# create user "guy_on_stackoverflow" with password 'keepitonthedl';
postgres=# create database "dcaclab_development" owner "guy_on_stackoverflow";

Now update your database.yml file after you’ve confirmed creating the database, user, password and set these privileges. Don’t forget host: localhost.

More Related Contents:

  1. Ignoring time zones altogether in Rails and PostgreSQL
  2. Can’t find the ‘libpq-fe.h header when trying to install pg gem
  3. Can’t find the PostgreSQL client library (libpq)
  4. Repairing Postgresql after upgrading to OSX 10.7 Lion
  5. PG::Error: SELECT DISTINCT, ORDER BY expressions must appear in select list
  6. Installing Postgres on windows for use with Ruby-on-Rails
  7. Can we call a Controller’s method from a view (as we call from helper ideally)?
  8. Rails auto-assigning id that already exists
  9. Rails naming convention for join table
  10. Convert HTML to word file ?
  11. skip certain validation method in Model
  12. PGError: ERROR: aggregates not allowed in WHERE clause on a AR query of an object and its has_many objects
  13. Changing a column type to longer strings in rails
  14. Adding foreign key to a rails model
  15. How to make Devise redirect after confirmation
  16. Is the server running on host “localhost” (::1) and accepting TCP/IP connections on port 5432?
  17. No route matches “/users/sign_out” devise rails 3
  18. Rails DB Migration – How To Drop a Table?
  19. Rails 3: Get Random Record
  20. Setting session timeout in Rails 3
  21. How to handle Ruby on Rails error: “Please install the postgresql adapter: `gem install activerecord-postgresql-adapter'”
  22. Devise form within a different controller
  23. Devise limit one session per user at a time
  24. Using Rails link_to for links that post
  25. Rails 3 disabling session cookies
  26. Rails 3 check if attribute changed
  27. Passing variables inside rails internationalization yml file
  28. rails 3 has_many :through Form with checkboxes
  29. Customizing Devise error messages in Rails 3?
  30. An error occurred while installing pg (0.17.1), and Bundler cannot continue

Leave a Comment