Does WSL run postgres 11?

I was able to get PostgreSQL 9 running perfectly... but PostgreSQL 11 is having a service start up issue.

Distro: Debian Stretch. Postgres 9.6 worked under WSL.

Symptom: The PostgreSQL service crashes on a 'create database' command from psql.

Thanks!

Posted Feb 26, 2019, 8:52 PM UTC · edited

79
NoInkling•

You can always just run the Windows version, unless you have a good reason not to (sorry for the non-answer, just making sure you know that's an option).

8
Win8CoderOP•

Yup, I spun up a Linux Azure instance for Postgres 11 at the moment.

I have multiple dev locations and actually this makes it easier for now.

I used WSL because I could pull everything down from git and it would recreate the database in a script automatically such that everything was in sync between all of my dev instances.

WSL is great... will try a fresh install of postgres 11 at a later point.

Thanks.

1
nomaddave•

New install? Ran fine for me earlier... not much to share in the way of details. It just did. :(

3
Win8CoderOP•

Postgres 11 on Debian Stretch?

1
nomaddave•

Oh! Sorry, no, sadly. Just vanilla Ubuntu.

1
greven•

You will always have a service start up issue as I don't think WSL supports Systemd.

Like u/NoInkling suggested I would just run it on windows and use it as you would from linux (if you keep the port as the default you don't have to do anything else).

2
Marty_Br•

For me it does work just fine, but you're also not providing much detail. Can you tell us what the startup issue is, exactly? Any helpful messages or logs? Also, are you talking about the client or server?

​

That said, I would actually be inclined to agree with u/NoInkling, given the IO limitations of WSL. You'd be much better off running a postgres server on Windows and connecting to it with a client on WSL.

2
shinaku•

Wsl is more for terminal tools than something for running full services.

1
Win8CoderOP•

WSL was running Postgres 9.6 for me perfectly.

I just wanted to know if 11 was supported as it is crashing on a database create command.

Thanks.

1