Peer authentication failed for user "postgres"

Question

I have been using postgreSQL, trying to dump plain backup file using command:

psql -U postgres DATABASE < path to file.backup

But getting peer authentication failure. Even tried changing pg_hba.conf from peer to md5, but didn't work.

peer means you are not OS user postgres, while trying to connect as one, sudo su - postgres and then psql DBNAME >file.sql — Vao Tsun
– Vao Tsun, Commented Jun 20, 2017 at 10:43

Vao Tsun · Accepted Answer · 2017-06-20 11:18:06Z

5

peer means you are not OS user postgres, while trying to connect as one,

sudo su - postgres
and then psql DBNAME >file.sql

https://www.postgresql.org/docs/current/static/auth-methods.html#AUTH-PEER

The peer authentication method works by obtaining the client's operating system user name from the kernel and using it as the allowed database user name (with optional user name mapping). This method is only supported on local connections.

answered Jun 20, 2017 at 11:18

Vao Tsun

52.4k13 gold badges114 silver badges149 bronze badges

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

Collectives™ on Stack Overflow

Peer authentication failed for user "postgres"

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related