How to setup PostgreSQL and DBeaver on WSL.

Maneesha Walisundera — Sun, 28 Jan 2024 08:26:05 +0000

Spent a few hours trying to configure PostgreSQL and DBeaver on wsl. Hope this helps.

Installing postgresql on wsl terminal

$ sudo apt update
$ sudo apt install postgresql postgresql-contrib
$ psql --version

$ sudo passwd postgres

$ sudo service postgresql status
$ sudo service postgresql start

If you didn't, then type :

$ su - postgres
$ psql

postgres=#

It should ask you to download some drivers. After downloading it should be working.

If you get an error, lets try reseting password and creating dummydb.

$ sudo -u postgres createuser <username>
$ sudo -u postgres createdb <dummydbname>
$ sudo -u postgres psql

psql=# alter user postgres with encrypted password '<password>'
psql=# grant all privileges on database <dbname> to postgres

sudo ufw allow 5432/tcp
# You should see "Rules updated" and/or "Rules updated (v6)"
sudo service postgresql restart

Start postgresql service and Retry connection.