Breaking News: Grepper is joining You.com. Read the official announcement!

psql: error: FATAL: Peer authentication failed for user

Add Answer

barisx answered on December 14, 2020 Popularity 10/10 Helpfulness 4/10

answer psql: error: FATAL: Peer authentication failed for user

related Peer authentication failed for user "postgres"

related ubuntu psql: error: FATAL: Peer authentication failed for user

related postgresql Peer authentication failed

psql: error: FATAL: Peer authentication failed for user

Comment

# The problem is still your pg_hba.conf file*.
# This line:
local   all             postgres                                peer
# Should be:
local   all             postgres                                md5
# After altering this file, don't forget to restart 
# your PostgreSQL server. If you're on Linux, 
# that would be sudo service postgresql restart.

Popularity 10/10 Helpfulness 4/10 Language sql

Source: stackoverflow.com

Tags: authentication peer sql

Link to this answer
Share Copy Link

Contributed on Apr 25 2022

barisx

0 Answers Avg Quality 2/10

Closely Related Answers

Peer authentication failed for user "postgres"

Comment

########## dont forget to restart your server #########
sudo service postgresql restart.

Popularity 10/10 Helpfulness 9/10 Language whatever

Source: Grepper

Tags: authentication auth

Link to this answer
Share Copy Link

Contributed on Sep 19 2022

Testy Termite

0 Answers Avg Quality 2/10

ubuntu psql: error: FATAL: Peer authentication failed for user

Comment

local   all             postgres                                md5

Popularity 10/10 Helpfulness 2/10 Language shell

Source: stackoverflow.com

Tags: authentication auth

Link to this answer
Share Copy Link

Contributed on Dec 14 2020

Careful Cicada

0 Answers Avg Quality 2/10

postgresql Peer authentication failed

Comment

local   all             postgres                                peer

should be:

local   all             postgres                                peer

Popularity 8/10 Helpfulness 1/10 Language sql

Source: stackoverflow.com

Tags: authentication auth

Link to this answer
Share Copy Link

Contributed on Aug 09 2023

Bored Bug

0 Answers Avg Quality 2/10

psql: error: FATAL: Peer authentication failed for user

Contents

More Related Answers

psql: error: FATAL: Peer authentication failed for user

Closely Related Answers

Peer authentication failed for user "postgres"

ubuntu psql: error: FATAL: Peer authentication failed for user

postgresql Peer authentication failed

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.