fe sendauth no password supplied

Question

database yml     SQLite version 3 x     gem install sqlite3       Ensure the SQLite 3 gem is defined in your Gemfile     gem  sqlite3  development    adapter  postgresql   encoding  utf8   database  sampleapp dev   can be anything unique    host  localhost    username  7stud    password       adapter  sqlite3    database  db development sqlite3   pool  5   timeout  5000    Warning  The database defined as  test  will be erased and   re-generated from your development database when you run  rake     Do not set this db to the same as development or production  test    adapter  postgresql   encoding  utf8   database  sampleapp test   can be anything unique    host  localhost    username  7stud    password      adapter  sqlite3    database  db test sqlite3   pool  5   timeout  5000  production    adapter  postgresql   database  sampleapp prod    can be anything unique    host  localhost    username  7stud    password      adapter  sqlite3    database  db production sqlite3   pool  5   timeout  5000   pg hba conf     TYPE  DATABASE        USER            ADDRESS                 METHOD     local  is for Unix domain socket connections only local   all             all                                     trust   IPv4 local connections  host    all             all             127 0 0 1 32            trust   IPv6 local connections  host    all             all               1 128                 trust   Allow replication connections from localhost  by a user with the   replication privilege   local   replication     postgres                                md5  host    replication     postgres        127 0 0 1 32            md5  host    replication     postgres          1 128                 md5   I changed the METHOD in the first three lines from md5 to trust  but I still get the error   And no matter what combinations of things I try in database yml  when I do     rails projects sample app4 0  bundle exec rake db create all   I always get the error      fe sendauth  no password supplied   I followed this tutorial to get things setup   https   pragtob wordpress com 2012 09 12 setting-up-postgresql-for-ruby-on-rails-on-linux  Mac OSX 10 6 8 PostgreSQL 9 2 4 installed via enterpriseDB installer Install dir   Library PostgreSQL 9 2

User · Answer

Do not use passwords  Use peer authentication instead  postgres   myuser  2Fvar 2Frun 2Fpostgresql mydb

User · Answer

This occurs if the password for the database is not given      default  postgres   postgres password 127 0 0 1 5432 DBname

User · Answer

I just put --password flag into my command and after hitting Enter it asked me for password  which I supplied

User · Answer

After making changes to the pg hba conf or postgresql conf files  the cluster needs to be reloaded to pick up the changes   From the command line  pg ctl reload  From within a db  as superuser   select pg reload conf     From PGAdmin  right-click db name  select  Reload Configuration   Note  the reload is not sufficient for changes like enabling archiving  changing shared buffers  etc -- those require a cluster restart

[postgresql] fe_sendauth: no password supplied

Examples related to postgresql

Examples related to ruby-on-rails-4