Re: [Rails] Postgres issue

2018-08-08 Thread Piyush Chowhan
In terminal I have created a role user and password what I have given in database.yml file by this command below and I solved the problem. Thanks for your reply. psql -U postgres -- run console CREATE ROLE WITH LOGIN SUPERUSER PASSWORD 'X'; --- to create a role On Wednesday

Re: [Rails] Postgres issue

2018-08-08 Thread Khizer Mehdi
Piyush, As Mike suggested, can you set host,port setting explicitly in database.yml and can you re run rake db:create On Tue 7 Aug, 2018, 8:15 PM Piyush Chowhan, wrote: > Ya, I have tried with the login from the shell which I have given in the > database.yml file. > > On Tue, Aug 7, 2018 at 7

Re: [Rails] Postgres issue

2018-08-07 Thread Piyush Chowhan
Ya, I have tried with the login from the shell which I have given in the database.yml file. On Tue, Aug 7, 2018 at 7:58 PM, Hassan Schroeder wrote: > On Mon, Aug 6, 2018 at 10:59 PM, Piyush Chowhan > wrote: > > FATAL: Peer authentication failed for user "admin" > > Couldn't create database for

Re: [Rails] Postgres issue

2018-08-07 Thread Hassan Schroeder
On Mon, Aug 6, 2018 at 10:59 PM, Piyush Chowhan wrote: > FATAL: Peer authentication failed for user "admin" > Couldn't create database for {"adapter"=>"postgresql", > "encoding"=>"unicode", "database"=>"bookingsaround_diy_development", > "username"=>"admin", "password"=>"password"} > rake aborted

[Rails] Postgres issue

2018-08-07 Thread Mike
Peer Authentication used your OS username and password for access, you may need to change pg_hba.conf and change instances of peer to md5. This also assumes that the user has been created correctly in the PostgreSQL system. It may also help to use the lines host: localhost port: 5432 In your

[Rails] Postgres issue

2018-08-06 Thread Piyush Chowhan
FATAL: Peer authentication failed for user "admin" Couldn't create database for {"adapter"=>"postgresql", "encoding"=>"unicode", "database"=>"bookingsaround_diy_development", "username"=>"admin", "password"=>"password"} rake aborted! PG::ConnectionBad: FATAL: Peer authentication failed for user