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

database postgresql windows-subsystem-for-linux dirty-data
Someone picture Someone · Aug 1, 2017 · Viewed 11.6k times · Source

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

Oni picture Oni · Oct 29, 2019

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)

Related questions

How to select the nth row in a SQL database table?

I'm interested in learning some (ideally) database agnostic ways of selecting the nth row from a database table. It would also be interesting to see how this can be achieved using the native functionality of the following databases: SQL Server …

Read More
What is this Javascript "require"?

I'm trying to get Javascript to read/write to a PostgreSQL database. I found this project on github. I was able to get the following sample code to run in node. var pg = require('pg'); //native libpq bindings = `var pg = …

Read More
Import SQL dump into PostgreSQL database

We are switching hosts and the old one provided a SQL dump of the PostgreSQL database of our site. Now, I'm trying to set this up on a local WAMP server to test this. The only problem is that I …

Read More