Auth_001

Peer vs Password

• See this stackoverflow
• See the docs on authentication methods

In /etc/postgresql/15/main/ edit the file pg_hba.conf. Choose peer or md5 as needed.

Change

local   all             all                                peer

to

local   all             all                                md5