psql: FATAL: Peer authentication failed for user

UpdatedJuly 7, 2023

Student

The order of rules in pg_hba.conf matters.

Trying to connect to postgresql database with a standard user fails with psql: FATAL: Peer authentication failed fr user "user1".

The second line of pg_hba.conf makes your connection attempt fail:

local   all     all     peer

The order of rules matter. If the first one that matches the access method, username, database name and source IP range fails, there will be no second attempt. So either remove this line, your place your rule above this one.

Comments

Join the discussion

No comments yet. Be the first to comment.

More from this blog

Use GUI Programs in Incus Container

If you've ever faced the challenge of running graphical user interface (GUI) programs within a container, fear not! While it may seem like a daunting task at first, with this comprehensive guide, we'll walk through the process using Incus Container. ...

Apr 28, 20243 min read10

Mount Shared Directories in Incus

When working with containers, managing file sharing between the host system and container can often pose a challenge. However, there is an easy-to-use solution that simplifies this process using just one line of code! This blog post will guide you on...

Apr 27, 20241 min read10

Install Incus on NixOS

Incus, a manager and hypervisor for system containers (LXC) and virtual machines (QEMU), is an excellent tool for managing and orchestrating your applications and services. It is a fork of LXD by the original maintainers. I found the documentation re...

Feb 29, 20243 min read33

Make Bash prettier on NixOS

Using ble.sh and Starship. Bash by itself is pretty basic. Syntax highlighting, auto-suggestion and history matching are pretty helpful features in any shell. Users might be worried about the bloat these features bring and add delay to the startup of...

Feb 29, 20242 min read10

Troubleshooting Internet Connectivity Issues in Virtual Machines (VMs) and Docker Containers

The ability to run virtual machines (VMs) and docker containers is an integral part of today’s modern computing landscape. However, issues with internet connectivity inside these environments often cause significant inconvenience for users who depend...

Jan 3, 20243 min read9

Troubleshooting Internet Connectivity Issues in Virtual Machines (VMs) and Docker Containers

Aditya's blog

57 posts

Who tricked sands into thinking?

Command Palette

Comments

More from this blog