Postgresql warning: "could not flush dirty data: Function not implemented"

Question

I'm trying to create a new database on postgres, by running command:

CREATE DATABASE dbname;

and I face the error:

WARNING: could not flush dirty data: Function not implemented

many times! and finally I get the message

CREATE DATABASE

Can anyone help me to undrestand and solve this error please?

Answer 1

I solved the problem by updating postgresql.conf file. Add the following codes at the end of /etc/postgresql/11/main/postgresql.conf.

fsync = off
data_sync_retry = true

(Corrected underscores)

Answer 2

You need Windows 15025 build for it to function properly, as underlying ubuntu in windows was still in beta before. Even after this build there are still issues remaining.

If update is not yet available to you you can still install Postgres directly on Windows