Password Authentication Failed with Database PostgreSQL 9.3 in Ubuntu

Question

I've installed PostgreSQL 9.3 in Ubuntu and I've created a new user "myuser". In fact if I write psql -U postgres -c'\du+' I get

                                    List of roles
Role name |                   Attributes                   | Member of |  Description 
----------+------------------------------------------------+-----------+-------------
postgres  | Superuser, Create role, Create DB, Replication | {}        | 
myuser    |                                                | {}        |

Now I want to modify the password for "myuser" and then create a new database. So I wrote

psql \password myuser
Password for user myuser: bla bla...

but I get the error

psql: FATAL:  password authentication failed for user "myuser"

but I don't remember to have created a previous password. Ok, no problem. I decide to delete this user and so I wrote:

dropuser myuser
Password: what? bla bla...
dropuser: could not connect to database postgres: FATAL: password authentication failed for user "strange_user"

strange_user is a fancy name... but I don't know who is... There's a way to fix this issue?

My pg_hba.conf is:

# Database administrative login by Unix domain socket
local   all             postgres                                md5

# TYPE  DATABASE        USER            ADDRESS                 METHOD

# "local" is for Unix domain socket connections only
local   all             all                                     md5
# IPv4 local connections:
host    all             all             127.0.0.1/32            md5
# IPv6 local connections:
host    all             all             ::1/128                 md5

Could you post your pg_hba.conf ?

ehoffmann
– ehoffmann

2015-11-12 14:50:59 +00:00
Commented Nov 12, 2015 at 14:50 — ehoffmann
– ehoffmann, Commented Nov 12, 2015 at 14:50
yep, I edit the original message

El_Merendero
– El_Merendero

2015-11-12 15:05:32 +00:00
Commented Nov 12, 2015 at 15:05 — El_Merendero
– El_Merendero, Commented Nov 12, 2015 at 15:05

Henrik supports the community · Accepted Answer · 2015-11-12 15:19:39Z

1

I think your problem might be that portgres doesn't know what postgres role (user) you want to connect as when you try to set the password or drop the user.

Try something like `psql -U postgres -c "ALTER ROLE myuser ENCRYPTED PASSWORD 's3kr1t'.

edited Nov 12, 2015 at 15:19

answered Nov 12, 2015 at 11:46

Henrik supports the community

8191 gold badge8 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

7 Comments

El_Merendero Over a year ago

I get psql: FATAL: database "ALTER ROLE myuser ENCRYPTED PASSWORD 's3kr1t'" does not exist.

Henrik supports the community Over a year ago

I have added an option (-c) to the command that should solve that.

El_Merendero Over a year ago

ok it seem to work. but just let me understand. In this way I simply change the password for myuser and set it as s3kr1t (or whatever I want)? Eventually there's a way to be sure that the password set is correct?

Henrik supports the community Over a year ago

Just connect as myuser to be sure the password is as you expect.

El_Merendero Over a year ago

And how can I connect me as myuser?

|

Collectives™ on Stack Overflow

Password Authentication Failed with Database PostgreSQL 9.3 in Ubuntu

1 Answer 1

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related