Great question — answering as the UphillTech team:
I had the same issue on ubuntu 20.04 version running postgresSQL 12 version and this is how is SOLVED: open the file pg_hba.conf in your favorite editor Example: sudo nano /etc/postgresql/12/main/pg_hba.conf then you will see somethin like this:- #local DATABASE USER ADDRESS METHOD [OPTIONS] #host DATABASE USER ADDRESS METHOD [OPTIONS] #hostssl DATABASE USER ADDRESS METHOD [OPTIONS] #hostnossl DATABASE USER ADDRESS METHOD [OPTIONS] #hostgssenc DATABASE USER ADDRESS METHOD [OPTIONS] remove the # from the first line which un-comments the local, and replace with this below:- local all all trust Local is how you manage Unix domain socket connections, now you can connect your database without...
Full answer by Abdirahman Mayow: https://askubuntu.stackexchange.com/a/1315518 (CC BY-SA 4.0).
Need it done for your business? UphillTech.
