Connect to existing instance of Postgresql from WSL 2

Question

I'm running Ubuntu WSL 2 on Windows 10. Before I installed WSL I already had Postgresql installed on my Windows 10. I wanted to connect to the database from WSL but so far it fails.

When running:

psql

I get:

psql: error: could not connect to server: Connection refused
    Is the server running on host "127.0.0.1" and accepting
    TCP/IP connections on port 5432?

When running:

psql -h 127.0.0.1 -p 5432 -U postgres

I get:

psql: error: could not connect to server: Connection refused
    Is the server running on host "127.0.0.1" and accepting
    TCP/IP connections on port 5432?

And WSL clearly doesn't see the database. When running this:

sudo service postgresql start

It returns:

postgresql: unrecognized service

I know that one solution is to install the database in WSL but wanted to try to connect to existing instance first.

Use the local network address as opposed to the loopback address when using psql -h 127.0.0.1 -p 5432 -U postgres — Raman Sailopal
– Raman Sailopal, Commented Jan 12, 2021 at 9:46
@RamanSailopal I think I tried that too. I extracted the address using grep nameserver /etc/resolv.conf | awk '{print $2}' — PiotrWolkowski
– PiotrWolkowski, Commented Jan 12, 2021 at 11:28
It should be one of the addresses shown by executing "ip add show" — Raman Sailopal
– Raman Sailopal, Commented Jan 12, 2021 at 11:36
Did you ever solve this? Having the same issue today. Yesterday it was working fine, today I can't connect. Although I don't get the error message on the service start, it just accepts the command. — Matt West
– Matt West, Commented Apr 7, 2021 at 16:06

S.Hashiba · Accepted Answer · 2022-05-06 22:38:29Z

12

You should edit pg_hba.conf

check wsl subnet
execute ipconfig from cmd. Below is example.

Ethernet Adapter vEthernet (WSL)
   IPv4 Address . . . . . . . . . . . .: 172.19.230.81

edit pg_hba.conf
pg_hba.conf path is C:\Program Files\PostgreSQL\{postgresqlVersion}\data\pg_hba.conf. if you installed Windows Postgresql default install path.
subnet mask is use value from ipconfig

host    all     all     172.19.230.0/24 md5

restart postgresql you can restart postgresql from services.msc. service name is postgresql-x64-{postgresqlVersion}.
access from psql

psql -h 172.19.230.81 -p 5432 -U postgres

edited May 6, 2022 at 22:38

answered Apr 19, 2021 at 0:59

S.Hashiba

6957 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Connect to existing instance of Postgresql from WSL 2

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related