Connecting PostgreSQL running on WSL from DBeaver on Windows (FATAL: password authentication failed for user “postgres”)
I have my WSL2 running an Ubuntu 20.04 distro. I have installed my PostgreSQL (12.19) using apt-get.
I ran the sudo passwd postgres to set password as root
I am able to access the DB from the WSL terminal using the command sudo -u postgres psql