Re: WSL (windows subsystem on linux) users will need to turn fsync off as of 11.2

From: Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com>
To: Andres Freund <andres(at)anarazel(dot)de>
Cc: Ravi Krishna <srkrishna(at)yahoo(dot)com>, "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: WSL (windows subsystem on linux) users will need to turn fsync off as of 11.2
Date: 2019-02-18 22:14:16
Message-ID: CAEepm=1Hx+t3O2u+UE9RLC-jvTXp-CLLtdfDfapAGEBk_-0Tsw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Feb 19, 2019 at 6:01 AM Andres Freund <andres(at)anarazel(dot)de> wrote:
> On 2019-02-18 10:33:50 -0500, Ravi Krishna wrote:
> > Are there any plans to support PG on WSL ? Just curious.

Hi Ravi,

I definitely want to fix this particular issue for 11.3.

> I think if somebody wanted to start investing efforts to improve testing
> of that setup, and then fix the resulting issues, nobody would seriously
> object. But also most people working on PG are already busy. Please
> feel free to create a buildfarm test machine with postgres running on
> WSL.

Right, the first step would be for a WSL user to figure out what's
wrong with builds on the WSL and show us how to fix it; I heard
through the grapevine that if you try it, initdb doesn't work (it must
be something pretty subtle in the configure phase or something like
that, since the Ubuntu .deb apparently works, except for the issue
reported in this thread). Then, confirm that they're happy with
whatever patch we come up with. Then if someone wants to make sure we
don't accidentally break it in future, yeah, a build farm animal would
help a lot.

Here's a starter patch that shows one of the approaches discussed. It
gets WSL users to a better place than they were before, by suppressing
further warnings after the first one.

--
Thomas Munro
http://www.enterprisedb.com

--
<https://postgresvision.com/>
<https://postgresvision.com/>

Attachment Content-Type Size
0001-Tolerate-ENOSYS-failure-from-sync_file_range.patch application/octet-stream 1.9 KB

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jitendra Loyal 2019-02-18 23:39:16 Re: Statement-level trigger results in recursion
Previous Message Adrian Klaver 2019-02-18 21:55:09 Re: BEFORE ... Statement-level trigger