Windows Linux Subsystem and postgresql connection failed

Question

There seems to be lots of questions likes this on stackoverflow, but none of them seemed to help me. I am runing Ubuntu on my windows linux subsystem and trying to install and use postgresql.

I installed in like this:

sudo apt-get install postgresql postgresql-contrib postgresql-client
pgadmin3

which worked fine:

near the bottom the install log says:

Creating new cluster 9.5/main ...
  config /etc/postgresql/9.5/main
  data   /var/lib/postgresql/9.5/main
  locale C
  socket /var/run/postgresql
  port   5433
update-alternatives: using /usr/share/postgresql/9.5/man/man1/postmaster.1.gz to provide /usr/share/man/man1/postmaster.1.gz (postmaster.1.gz) in auto mode
invoke-rc.d: could not determine current runlevel
Setting up postgresql (9.5+173) ...
Setting up postgresql-client (9.5+173) ...
Setting up postgresql-contrib-9.5 (9.5.8-0ubuntu0.16.04.1) ...
Setting up postgresql-contrib (9.5+173) ...
Processing triggers for systemd (229-4ubuntu16) ...
Processing triggers for ureadahead (0.100.0-19) ...

So the port is 5433. This is also the port listed in the postgresql.conf file.

When I type psql I get:

psql: could not connect to server: No such file or directory
        Is the server running locally and accepting
        connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5433"?

When I do:

ps -df | grep postgres

I get a different port though (5432) and this is returned:

spotter     12     2  0 18:55 tty1     00:00:00 /usr/lib/postgresql/9.5/bin/psql -h 199.92.170.64 -d rtu_prod -Usv-read -p 5432
spotter   1835     2  0 20:21 tty1     00:00:00 grep --color=auto -a postgres
spotter   6134     2  0 20:51 tty1     00:00:00 grep --color=auto -a postgres
spotter   9348     2  0 22:06 tty1     00:00:00 grep --color=auto postgres

I think this might mean I have two versions of postgresql installed but I'm not sure.

Based on other posts I should enter /usr/lib/postgresql/9.5/bin/psql -h 199.92.170.64 -d rtu_prod -Usv-read -p 5432 to start it, but this asks for a password I have never heard of Password for user sv-read:

first one returned psql: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/tmp/.s.PGSQL.5432"? Interesting its a different socket. The second one returned: psql: FATAL: could not load pg_hba.conf I may have two versions of posgresql installed then... — Stefano Potter
– Stefano Potter, Commented Sep 20, 2017 at 2:59
TBH I don't know if PostgreSQL even works on the Windows Linux subsystem. We don't have a buildfarm member to test it at the moment as nobody has cared. It depends on just how compatible it truly is. Why don't you just use the native Windows PostgreSQL instead? — Craig Ringer
– Craig Ringer, Commented Sep 20, 2017 at 3:27
It works in WSL, I want to use in WSL to learn how to use without a GUI. I connected to a colleagues database with psql -h 199.xx.xxx.64 -d rtk_prcd -U sv-read -p 5432 and I got in fine, so I don't know whats going on. — Stefano Potter
– Stefano Potter, Commented Sep 20, 2017 at 14:00
@CraigRinger adding '-h localhost' to commands made it work for me. 'psql', 'createdb db_name' etc. gave me the error. 'psql -h localhost', 'createdb db_name -h localhost' both worked. — acmshar
– acmshar, Commented Jul 5, 2018 at 19:30

Alvaro · Accepted Answer · 2019-03-17 13:16:57Z

5

PostgreSQL works just fine with WSL. To fully run it, follow these steps:

Installation Steps:

sudo apt update
sudo apt install postgresql postgresql-contrib
sudo service postgresql start
sudo -i -u postgres
psql

User setup from psql:

CREATE USER <Your User name> WITH PASSWORD '<Your Password>';
CREATE DATABASE <Your database> WITH OWNER <Your User name>;
\password postgres

answered Mar 17, 2019 at 13:16

Alvaro

1,4483 gold badges24 silver badges43 bronze badges

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

Collectives™ on Stack Overflow

Windows Linux Subsystem and postgresql connection failed

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