Postgresql warning: "could not flush dirty data: Function not implemented"
11,571
Solution 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)
Solution 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
Related videos on Youtube
Author by
Someone
Updated on June 04, 2022Comments
-
Someone almost 2 years
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?
-
joanolo over 6 yearsWhich specific version of PostgreSQL are you using? Which OS?
-
joanolo over 6 yearsApparently, you're not the only one with this issue: install postgresql issue #61 and Running Docker containers on Windows, natively, using rkt (WSL aka Bash on Windows). It seems to be some kind of "missing feature"
-
-
Oni over 4 yearsYou may get the same error after fixing issue and starting app again. Restart the postgresql service again at the moment.
sudo service postgresql restart