WSL (windows subsystem on linux) users will need to turn fsync off as of 11.2

From: Bruce Klein <brucek(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: WSL (windows subsystem on linux) users will need to turn fsync off as of 11.2
Date: 2019-02-15 00:33:48
Message-ID: CA+mCpegfOUph2U4ZADtQT16dfbkjjYNJL1bSTWErsazaFjQW9A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Just in case this helps the next person who can't figure out why their
postgres server won't start today:

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.

This took me a while to fix because the error you message you get if you
don't is the generic:

terminating connection because of crash of another server process
2015-07-15 20:18:37 UTC The postmaster has commanded this server process to
roll back the current transaction and exit, because another server process
exited abnormally and possibly corrupted shared memory.

I spent a long time trying to completely uninstall and resintall, etc. to
recover from the "crash" although I don't think there ever was one and the
message appears on first use of the create database command even on a
completely clean install.

I don't know if this is possible/reasonable, but if the database code could
automatically turn fsync off on WSL it might save the next users some
trouble.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2019-02-15 00:34:49 Re: loading plpython error
Previous Message Adrian Klaver 2019-02-15 00:27:54 Re: loading plpython error