nduagoziem's avatar

Connect Pgsql On WSL2 Ubuntu to Dbeaver installed on Windows

I'm running PostgreSQL on WSL2, and I want to use DBeaver as a GUI, which is installed on Windows. How can I achieve this? I've tried various ways, but I'm getting a connection reset error

0 likes
1 reply
JussiMannisto's avatar

It should work if you add a new database connection with 127.0.0.1 as the host, along with the correct port and user credentials.

Are you trying to connect as the postgres user? I haven't used Postgres recently, but in MySQL/MariaDB, the root user is nowadays restricted from connecting via TCP sockets by default, allowing only local Unix socket connections (as sudo). I'm not sure if Postgres has done the same, but if so, you may have to create another user for connecting from Windows.

1 like

Please or to participate in this conversation.