PostgreSQL

Common Errors

Peer authentication fails when using UNIX socket

  1. In /etc/postgresql/17/main/pg_hba.conf, change this line: 
    local   all             all                                     peer

    to: 

    local   all             all                                     md5