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?

Which specific version of PostgreSQL are you using? Which OS? — joanolo, Aug 01 '17 at 12:32
pgsql 9.6.3 on WindowsBashLinux (which has linux 16.04 on it) — Someone, Aug 01 '17 at 12:48
Apparently, you're not the only one with this issue: [install postgresql issue #61](https://github.com/Microsoft/BashOnWindows/issues/61) and [Running Docker containers on Windows, natively, using rkt (WSL aka Bash on Windows)](https://gist.github.com/drdaeman/84f10a7b9da9d2fe152e36b426bde00d). It seems to be some kind of "missing feature" — joanolo, Aug 01 '17 at 12:53

score 16 · Answer 1 · edited Nov 07 '19 at 16:11

16

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)

edited Nov 07 '19 at 16:11

Community

1
1

answered Oct 29 '19 at 22:07

Oni

1,093
11
16

1

You may get the same error after fixing issue and starting app again. Restart the postgresql service again at the moment. `sudo service postgresql restart` – Oni Oct 30 '19 at 09:09

score 2 · Answer 2 · answered Aug 01 '17 at 13:30

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

score 1 · Answer 3 · answered Nov 02 '22 at 20:16

The reason for this error is that the Windows emulation of Linux does not implement all system calls required to make a database work reliably. Originally PostgreSQL crashed when running there, but this has been downgraded to a warning.

Window's emulation of Linux is good to play with, but don't ever use it for serious work.

score 0 · Answer 4 · edited Nov 25 '21 at 22:23

0

Restarting the postgres sql did the trick for me

Use the following command

sudo service postgresql restart

edited Nov 25 '21 at 22:23

Peter Csala

17,736
16
35
75

answered Nov 25 '21 at 17:51

devops soft9

1

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

4 Answers4