Failed to connect to postgresql database with new created user

Question

After create a new user in my postgresql server with this commands:

#su postgres
CREATE ROLE kleber WITH LOGIN;
ALTER ROLE kleber WITH PASSWORD '...';

i try login with this user with this command:

# psql -U kleber -W

but I get this error:

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

what i am missing here?

Why are you using -W option of psql here when you have a password associated to the user kleber ? — avichalp
– avichalp, Commented Jun 6, 2016 at 14:47
-W asks psql to not to prompt for the password. If you want to use it use with pgpass file (postgresql.org/docs/9.4/static/libpq-pgpass.html) — avichalp
– avichalp, Commented Jun 6, 2016 at 14:55

avichalp · Accepted Answer · 2016-06-06 14:59:43Z

1

You should try: psql -h <hostname> -d <database name> -U <user>

On executing this command you will be prompted to enter the password for your user, kleber in this case. Enter the password for user kleber and this should work.

answered Jun 6, 2016 at 14:59

avichalp

1,13011 silver badges11 bronze badges

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

Collectives™ on Stack Overflow

Failed to connect to postgresql database with new created user

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related