Re: WSL (windows subsystem on linux) users will need to turn fsync off as of 11.2 - Mailing list pgsql-general

From Tom Lane
Subject Re: WSL (windows subsystem on linux) users will need to turn fsync off as of 11.2
Date
Msg-id 30532.1550191685@sss.pgh.pa.us
Whole thread Raw
In response to WSL (windows subsystem on linux) users will need to turn fsync off asof 11.2  (Bruce Klein <brucek@gmail.com>)
Responses Re: WSL (windows subsystem on linux) users will need to turn fsyncoff as of 11.2  (Bruce Klein <brucek@gmail.com>)
Re: WSL (windows subsystem on linux) users will need to turn fsyncoff as of 11.2  (Andres Freund <andres@anarazel.de>)
List pgsql-general
Bruce Klein <brucek@gmail.com> writes:
> If you are running Postgres inside Microsoft WSL (at least on Ubuntu, maybe
> on others too), and just picked up a software update to version 11.2, you
> will need to go into your /etc/postgresql.conf file and set fsync=off.

Hm.  Probably this is some unexpected problem with the
panic-on-fsync-failure change; although that still leaves some things
unexplained, because if fsync is failing for you now, why didn't it fail
before?  Anyway, you might try experimenting with data_sync_retry,
instead of running with scissors by turning off fsync altogether.
See first item in the release notes:

https://www.postgresql.org/docs/11/release-11-2.html

Also, we'd quite like to hear more details; can you find any PANIC
messages in the server log?

            regards, tom lane


pgsql-general by date:

Previous
From: Alan Hodgson
Date:
Subject: Re: loading plpython error
Next
From: Bruce Klein
Date:
Subject: Re: WSL (windows subsystem on linux) users will need to turn fsyncoff as of 11.2