PG::ConnectionBad: FATAL: password authentication failed for user "alphauser"

Madalina

I'm working on an application in Rails for my college. The application was started by the students from previous year and now it's me and my colleagues turn to continue work on it. I took the application from github, I run bundle install, but when to run rake db:migrate I got this PG::ConnectionBad: FATAL: password authentication failed for user "alphauser". In database.yml I have these

 development:
  adapter: postgresql
  encoding: unicode
  database: alpha_database
  host: localhost
  pool: 5
  username: alphauser
  password: alphapassword

I don't know what to do in this case.

Mikhail Chuprynski

You have to create corresponding user and database manually like this:

in shell: psql

then:

  create user alphauser with password 'alphapassword';
  create database alpha_database owner alphauser;
  alter user alphauser superuser createrole createdb replication;
  \q

don't forget semicolons.

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at
0

Comments

0 comments
Login to comment

Related

From Java

Postgresql: password authentication failed for user "postgres"

From Java

psql: FATAL: Peer authentication failed for user "dev"

From Java

git remote: Invalid username or password. fatal: Authentication failed - ubuntu

From Java

FATAL: password authentication failed for user "postgres" (postgresql 11 with pgAdmin 4)

From Dev

FATAL: password authentication failed for user "postgres"

From Dev

heroku pg:pull password authentication failed

From Dev

PostgreSQL SSPI authentication - FATAL: 2801: password authentication failed for user "xxx"

From Dev

PG::ConnectionBad FATAL: role "BetBook3" is not permitted to log in

From Dev

PG::ConnectionBad FATAL: role "Myname" does not exist

From Dev

PG::ConnectionBad: fe_sendauth: no password supplied

From Dev

remote: Invalid username or password, fatal: Authentication failed for

From Dev

psql: FATAL: PAM authentication failed for user

From Dev

Redshift connection issue: FATAL: password authentication failed for user

From Dev

psql: FATAL: password authentication failed for user windows 8

From Dev

remote: Invalid username or password. fatal: Authentication failed for

From Dev

FATAL: Peer authentication failed for user "rails"

From Dev

How to solve " django.db.utils.OperationalError: FATAL: password authentication failed for user "Oeloun-pc" " in Pycharm Windows?

From Dev

FATAL: Peer authentication failed for user "shop"

From Dev

FATAL: password authentication failed for user "postgres" Ubuntu v20.10

From Dev

PG::ConnectionBad FATAL: role "Myname" does not exist

From Dev

PSQL - password authentication failed for user "postgres"

From Dev

PG::ConnectionBad fe_sendauth: no password supplied

From Dev

PostgreSQL: MD5 Authentication in pg_hba.conf gives me FATAL: Peer authentication failed for user "postgres"

From Dev

error: password authentication failed for user "myuser"

From Dev

jitterbit-password authentication failed for user "postgres"

From Dev

Rails 5 in prod: PG::ConnectionBad: FATAL: password authentication failed for user "postgres" with Docker

From Dev

PG::ConnectionBad: FATAL: Ident authentication failed for user "rails_dev"

From Dev

psql: FATAL: password authentication failed for user error while trying to access psql

From Dev

Password authentication failed for a user not in my role list

Related Related

  1. 1

    Postgresql: password authentication failed for user "postgres"

  2. 2

    psql: FATAL: Peer authentication failed for user "dev"

  3. 3

    git remote: Invalid username or password. fatal: Authentication failed - ubuntu

  4. 4

    FATAL: password authentication failed for user "postgres" (postgresql 11 with pgAdmin 4)

  5. 5

    FATAL: password authentication failed for user "postgres"

  6. 6

    heroku pg:pull password authentication failed

  7. 7

    PostgreSQL SSPI authentication - FATAL: 2801: password authentication failed for user "xxx"

  8. 8

    PG::ConnectionBad FATAL: role "BetBook3" is not permitted to log in

  9. 9

    PG::ConnectionBad FATAL: role "Myname" does not exist

  10. 10

    PG::ConnectionBad: fe_sendauth: no password supplied

  11. 11

    remote: Invalid username or password, fatal: Authentication failed for

  12. 12

    psql: FATAL: PAM authentication failed for user

  13. 13

    Redshift connection issue: FATAL: password authentication failed for user

  14. 14

    psql: FATAL: password authentication failed for user windows 8

  15. 15

    remote: Invalid username or password. fatal: Authentication failed for

  16. 16

    FATAL: Peer authentication failed for user "rails"

  17. 17

    How to solve " django.db.utils.OperationalError: FATAL: password authentication failed for user "Oeloun-pc" " in Pycharm Windows?

  18. 18

    FATAL: Peer authentication failed for user "shop"

  19. 19

    FATAL: password authentication failed for user "postgres" Ubuntu v20.10

  20. 20

    PG::ConnectionBad FATAL: role "Myname" does not exist

  21. 21

    PSQL - password authentication failed for user "postgres"

  22. 22

    PG::ConnectionBad fe_sendauth: no password supplied

  23. 23

    PostgreSQL: MD5 Authentication in pg_hba.conf gives me FATAL: Peer authentication failed for user "postgres"

  24. 24

    error: password authentication failed for user "myuser"

  25. 25

    jitterbit-password authentication failed for user "postgres"

  26. 26

    Rails 5 in prod: PG::ConnectionBad: FATAL: password authentication failed for user "postgres" with Docker

  27. 27

    PG::ConnectionBad: FATAL: Ident authentication failed for user "rails_dev"

  28. 28

    psql: FATAL: password authentication failed for user error while trying to access psql

  29. 29

    Password authentication failed for a user not in my role list

HotTag

Archive