Rails 4.0.4, ruby 2.1.0, Ubuntu 12.04 rake db:create fails, postgresql making me sad -

using ubuntu 12.04

i know problem isn't new, googled extensively, check stackoverflow, followed solutions suggested letter - alas, no avail.

i have app in rails 4.0.4, ruby 2.1.0, deploy heroku. have: installed pg 0.15.1 (tried 0.17.1 well) gem, sudo apt-get installed postgresql, added host: localhost database.yaml file, edited /etc/postgresql/9.1/main/postgresql.conf , uncommented listen_addresses = 'localhost',

added user 'postgres' password 'blah' psql database, tried rake db:create - failed spectacularly.

please advise.

    fatal:  password authentication failed user "postgresql" fatal:  password authentication failed user "postgresql" /usr/local/lib/ruby/gems/2.1.0/gems/activerecord-4.0.4/lib/active_record/connection_adapters/postgresql_adapter.rb:848:in `initialize' /usr/local/lib/ruby/gems/2.1.0/gems/activerecord-4.0.4/lib/active_record/connection_adapters/postgresql_adapter.rb:848:in `new' /usr/local/lib/ruby/gems/2.1.0/gems/activerecord-4.0.4/lib/active_record/connection_adapters/postgresql_adapter.rb:848:in `connect' /usr/local/lib/ruby/gems/2.1.0/gems/activerecord-4.0.4/lib/active_record/connection_adapters/postgresql_adapter.rb:556:in `initialize' /usr/local/lib/ruby/gems/2.1.0/gems/activerecord-4.0.4/lib/active_record/connection_adapters/postgresql_adapter.rb:41:in `new' /usr/local/lib/ruby/gems/2.1.0/gems/activerecord-4.0.4/lib/active_record/connection_adapters/postgresql_adapter.rb:41:in `postgresql_connection' /usr/local/lib/ruby/gems/2.1.0/gems/activerecord-4.0.4/lib/active_record/connection_adapters/abstract/connection_pool.rb:440:in `new_connection' /usr/local/lib/ruby/gems/2.1.0/gems/activerecord-4.0.4/lib/active_record/connection_adapters/abstract/connection_pool.rb:450:in `checkout_new_connection' /usr/local/lib/ruby/gems/2.1.0/gems/activerecord-4.0.4/lib/active_record/connection_adapters/abstract/connection_pool.rb:421:in `acquire_connection' /usr/local/lib/ruby/gems/2.1.0/gems/activerecord-4.0.4/lib/active_record/connection_adapters/abstract/connection_pool.rb:356:in `block in checkout' /usr/local/lib/ruby/2.1.0/monitor.rb:211:in `mon_synchronize' /usr/local/lib/ruby/gems/2.1.0/gems/activerecord-4.0.4/lib/active_record/connection_adapters/abstract/connection_pool.rb:355:in `checkout' /usr/local/lib/ruby/gems/2.1.0/gems/activerecord-4.0.4/lib/active_record/connection_adapters/abstract/connection_pool.rb:265:in `block in connection' /usr/local/lib/ruby/2.1.0/monitor.rb:211:in `mon_synchronize' /usr/local/lib/ruby/gems/2.1.0/gems/activerecord-4.0.4/lib/active_record/connection_adapters/abstract/connection_pool.rb:264:in `connection' /usr/local/lib/ruby/gems/2.1.0/gems/activerecord-4.0.4/lib/active_record/connection_adapters/abstract/connection_pool.rb:546:in `retrieve_connection' /usr/local/lib/ruby/gems/2.1.0/gems/activerecord-4.0.4/lib/active_record/connection_handling.rb:79:in `retrieve_connection' /usr/local/lib/ruby/gems/2.1.0/gems/activerecord-4.0.4/lib/active_record/connection_handling.rb:53:in `connection' /usr/local/lib/ruby/gems/2.1.0/gems/activerecord-4.0.4/lib/active_record/tasks/postgresql_database_tasks.rb:8:in `connection' /usr/local/lib/ruby/gems/2.1.0/gems/activerecord-4.0.4/lib/active_record/tasks/postgresql_database_tasks.rb:17:in `create' /usr/local/lib/ruby/gems/2.1.0/gems/activerecord-4.0.4/lib/active_record/tasks/database_tasks.rb:73:in `create' /usr/local/lib/ruby/gems/2.1.0/gems/activerecord-4.0.4/lib/active_record/tasks/database_tasks.rb:87:in `block in create_current' /usr/local/lib/ruby/gems/2.1.0/gems/activerecord-4.0.4/lib/active_record/tasks/database_tasks.rb:183:in `block in each_current_configuration' /usr/local/lib/ruby/gems/2.1.0/gems/activerecord-4.0.4/lib/active_record/tasks/database_tasks.rb:182:in `each' /usr/local/lib/ruby/gems/2.1.0/gems/activerecord-4.0.4/lib/active_record/tasks/database_tasks.rb:182:in `each_current_configuration' /usr/local/lib/ruby/gems/2.1.0/gems/activerecord-4.0.4/lib/active_record/tasks/database_tasks.rb:86:in `create_current' /usr/local/lib/ruby/gems/2.1.0/gems/activerecord-4.0.4/lib/active_record/railties/databases.rake:20:in `block (2 levels) in <top (required)>' /usr/local/lib/ruby/gems/2.1.0/gems/rake-10.2.2/lib/rake/task.rb:240:in `call' /usr/local/lib/ruby/gems/2.1.0/gems/rake-10.2.2/lib/rake/task.rb:240:in `block in execute' /usr/local/lib/ruby/gems/2.1.0/gems/rake-10.2.2/lib/rake/task.rb:235:in `each' /usr/local/lib/ruby/gems/2.1.0/gems/rake-10.2.2/lib/rake/task.rb:235:in `execute' /usr/local/lib/ruby/gems/2.1.0/gems/rake-10.2.2/lib/rake/task.rb:179:in `block in invoke_with_call_chain' /usr/local/lib/ruby/2.1.0/monitor.rb:211:in `mon_synchronize' /usr/local/lib/ruby/gems/2.1.0/gems/rake-10.2.2/lib/rake/task.rb:172:in `invoke_with_call_chain' /usr/local/lib/ruby/gems/2.1.0/gems/rake-10.2.2/lib/rake/task.rb:165:in `invoke' /usr/local/lib/ruby/gems/2.1.0/gems/rake-10.2.2/lib/rake/application.rb:150:in `invoke_task' /usr/local/lib/ruby/gems/2.1.0/gems/rake-10.2.2/lib/rake/application.rb:106:in `block (2 levels) in top_level' /usr/local/lib/ruby/gems/2.1.0/gems/rake-10.2.2/lib/rake/application.rb:106:in `each' /usr/local/lib/ruby/gems/2.1.0/gems/rake-10.2.2/lib/rake/application.rb:106:in `block in top_level' /usr/local/lib/ruby/gems/2.1.0/gems/rake-10.2.2/lib/rake/application.rb:115:in `run_with_threads' /usr/local/lib/ruby/gems/2.1.0/gems/rake-10.2.2/lib/rake/application.rb:100:in `top_level' /usr/local/lib/ruby/gems/2.1.0/gems/rake-10.2.2/lib/rake/application.rb:78:in `block in run' /usr/local/lib/ruby/gems/2.1.0/gems/rake-10.2.2/lib/rake/application.rb:176:in `standard_exception_handling' /usr/local/lib/ruby/gems/2.1.0/gems/rake-10.2.2/lib/rake/application.rb:75:in `run' /usr/local/lib/ruby/gems/2.1.0/gems/rake-10.2.2/bin/rake:33:in `<top (required)>' /usr/local/bin/rake:23:in `load' /usr/local/bin/rake:23:in `<main>' couldn't create database {"adapter"=>"postgresql", "database"=>"development", "pool"=>5, "timeout"=>5000, "host"=>"localhost", "user"=>"postgresql", "password"=>"blah"} fatal:  password authentication failed user "postgresql" fatal:  password authentication failed user "postgresql" /usr/local/lib/ruby/gems/2.1.0/gems/activerecord-4.0.4/lib/active_record/connection_adapters/postgresql_adapter.rb:848:in `initialize' /usr/local/lib/ruby/gems/2.1.0/gems/activerecord-4.0.4/lib/active_record/connection_adapters/postgresql_adapter.rb:848:in `new' /usr/local/lib/ruby/gems/2.1.0/gems/activerecord-4.0.4/lib/active_record/connection_adapters/postgresql_adapter.rb:848:in `connect' /usr/local/lib/ruby/gems/2.1.0/gems/activerecord-4.0.4/lib/active_record/connection_adapters/postgresql_adapter.rb:556:in `initialize' /usr/local/lib/ruby/gems/2.1.0/gems/activerecord-4.0.4/lib/active_record/connection_adapters/postgresql_adapter.rb:41:in `new' /usr/local/lib/ruby/gems/2.1.0/gems/activerecord-4.0.4/lib/active_record/connection_adapters/postgresql_adapter.rb:41:in `postgresql_connection' /usr/local/lib/ruby/gems/2.1.0/gems/activerecord-4.0.4/lib/active_record/connection_adapters/abstract/connection_pool.rb:440:in `new_connection' /usr/local/lib/ruby/gems/2.1.0/gems/activerecord-4.0.4/lib/active_record/connection_adapters/abstract/connection_pool.rb:450:in `checkout_new_connection' /usr/local/lib/ruby/gems/2.1.0/gems/activerecord-4.0.4/lib/active_record/connection_adapters/abstract/connection_pool.rb:421:in `acquire_connection' /usr/local/lib/ruby/gems/2.1.0/gems/activerecord-4.0.4/lib/active_record/connection_adapters/abstract/connection_pool.rb:356:in `block in checkout' /usr/local/lib/ruby/2.1.0/monitor.rb:211:in `mon_synchronize' /usr/local/lib/ruby/gems/2.1.0/gems/activerecord-4.0.4/lib/active_record/connection_adapters/abstract/connection_pool.rb:355:in `checkout' /usr/local/lib/ruby/gems/2.1.0/gems/activerecord-4.0.4/lib/active_record/connection_adapters/abstract/connection_pool.rb:265:in `block in connection' /usr/local/lib/ruby/2.1.0/monitor.rb:211:in `mon_synchronize' /usr/local/lib/ruby/gems/2.1.0/gems/activerecord-4.0.4/lib/active_record/connection_adapters/abstract/connection_pool.rb:264:in `connection' /usr/local/lib/ruby/gems/2.1.0/gems/activerecord-4.0.4/lib/active_record/connection_adapters/abstract/connection_pool.rb:546:in `retrieve_connection' /usr/local/lib/ruby/gems/2.1.0/gems/activerecord-4.0.4/lib/active_record/connection_handling.rb:79:in `retrieve_connection' /usr/local/lib/ruby/gems/2.1.0/gems/activerecord-4.0.4/lib/active_record/connection_handling.rb:53:in `connection' /usr/local/lib/ruby/gems/2.1.0/gems/activerecord-4.0.4/lib/active_record/tasks/postgresql_database_tasks.rb:8:in `connection' /usr/local/lib/ruby/gems/2.1.0/gems/activerecord-4.0.4/lib/active_record/tasks/postgresql_database_tasks.rb:17:in `create' /usr/local/lib/ruby/gems/2.1.0/gems/activerecord-4.0.4/lib/active_record/tasks/database_tasks.rb:73:in `create' /usr/local/lib/ruby/gems/2.1.0/gems/activerecord-4.0.4/lib/active_record/tasks/database_tasks.rb:87:in `block in create_current' /usr/local/lib/ruby/gems/2.1.0/gems/activerecord-4.0.4/lib/active_record/tasks/database_tasks.rb:183:in `block in each_current_configuration' /usr/local/lib/ruby/gems/2.1.0/gems/activerecord-4.0.4/lib/active_record/tasks/database_tasks.rb:182:in `each' /usr/local/lib/ruby/gems/2.1.0/gems/activerecord-4.0.4/lib/active_record/tasks/database_tasks.rb:182:in `each_current_configuration' /usr/local/lib/ruby/gems/2.1.0/gems/activerecord-4.0.4/lib/active_record/tasks/database_tasks.rb:86:in `create_current' /usr/local/lib/ruby/gems/2.1.0/gems/activerecord-4.0.4/lib/active_record/railties/databases.rake:20:in `block (2 levels) in <top (required)>' /usr/local/lib/ruby/gems/2.1.0/gems/rake-10.2.2/lib/rake/task.rb:240:in `call' /usr/local/lib/ruby/gems/2.1.0/gems/rake-10.2.2/lib/rake/task.rb:240:in `block in execute' /usr/local/lib/ruby/gems/2.1.0/gems/rake-10.2.2/lib/rake/task.rb:235:in `each' /usr/local/lib/ruby/gems/2.1.0/gems/rake-10.2.2/lib/rake/task.rb:235:in `execute' /usr/local/lib/ruby/gems/2.1.0/gems/rake-10.2.2/lib/rake/task.rb:179:in `block in invoke_with_call_chain' /usr/local/lib/ruby/2.1.0/monitor.rb:211:in `mon_synchronize' /usr/local/lib/ruby/gems/2.1.0/gems/rake-10.2.2/lib/rake/task.rb:172:in `invoke_with_call_chain' /usr/local/lib/ruby/gems/2.1.0/gems/rake-10.2.2/lib/rake/task.rb:165:in `invoke' /usr/local/lib/ruby/gems/2.1.0/gems/rake-10.2.2/lib/rake/application.rb:150:in `invoke_task' /usr/local/lib/ruby/gems/2.1.0/gems/rake-10.2.2/lib/rake/application.rb:106:in `block (2 levels) in top_level' /usr/local/lib/ruby/gems/2.1.0/gems/rake-10.2.2/lib/rake/application.rb:106:in `each' /usr/local/lib/ruby/gems/2.1.0/gems/rake-10.2.2/lib/rake/application.rb:106:in `block in top_level' /usr/local/lib/ruby/gems/2.1.0/gems/rake-10.2.2/lib/rake/application.rb:115:in `run_with_threads' /usr/local/lib/ruby/gems/2.1.0/gems/rake-10.2.2/lib/rake/application.rb:100:in `top_level' /usr/local/lib/ruby/gems/2.1.0/gems/rake-10.2.2/lib/rake/application.rb:78:in `block in run' /usr/local/lib/ruby/gems/2.1.0/gems/rake-10.2.2/lib/rake/application.rb:176:in `standard_exception_handling' /usr/local/lib/ruby/gems/2.1.0/gems/rake-10.2.2/lib/rake/application.rb:75:in `run' /usr/local/lib/ruby/gems/2.1.0/gems/rake-10.2.2/bin/rake:33:in `<top (required)>' /usr/local/bin/rake:23:in `load' /usr/local/bin/rake:23:in `<main>' couldn't create database {"adapter"=>"postgresql", "database"=>"test", "pool"=>5, "timeout"=>5000, "host"=>"localhost", "user"=>"postgresql", "password"=>"blah"} 

to create user in psql used: sudo -u postgres psql template1 , inside psql alter user command can't find anywhere :(

my database.yaml:

test:   adapter: postgresql   database: test   pool: 5   timeout: 5000   host: localhost   production:   adapter: postgresql   database: production   pool: 5   timeout: 5000   host: localhost  development:   adapter: postgresql   database: development   pool: 5   timeout: 5000   host: localhost 

solved database.yaml:

development:   encoding: unicode   adapter: postgresql   database: development   pool: 5   timeout: 5000   host: localhost   port: 5432   username: postgres   password: blah   test:   encoding: unicode   adapter: postgresql   database: test   pool: 5   timeout: 5000   host: localhost   port: 5432   username: postgres   password: blah   production:   encoding: unicode   adapter: postgresql   database: production   pool: 5   timeout: 5000   host: localhost   port: 5432   username: postgres   password: blah