Follow

Keep Up to Date with the Most Important News

By pressing the Subscribe button, you confirm that you have read and are agreeing to our Privacy Policy and Terms of Use
Contact

Access Postgresql database from WSL2 on windows in tableplus

I have a postgresql database on wsl2. But i want to open this in Tableplus. I also run applications in wsl2. I can access those in the browser with localhost:3000 or whatever port. But i can’t connect to the database on localhost:5432

What am i doing wrong here?

MEDevel.com: Open-source for Healthcare and Education

Collecting and validating open-source software for healthcare, education, enterprise, development, medical imaging, medical records, and digital pathology.

Visit Medevel

>Solution :

It’s most likely a configuration error in postgres. Standard configuration in postgres in postgresql.conf only listens to localhost. So you need to change it to:

listen_addresses = ‘*’

You can find the location of the file, by going into psql and running the following query:

SHOW config_file;

Add a comment

Leave a Reply

Keep Up to Date with the Most Important News

By pressing the Subscribe button, you confirm that you have read and are agreeing to our Privacy Policy and Terms of Use

Discover more from Dev solutions

Subscribe now to keep reading and get access to the full archive.

Continue reading