PostgreSQL Bugs

Collected from the PG bugs email list.

Bug ID16526
PG Version12.3
OSwindows 2019
Opened2020-07-03 16:01:46+00
Reported byJeff Janes
StatusNew

Body of first available message related to this bug follows.

The following bug has been logged on the website:

Bug reference:      16526
Logged by:          Jeff Janes
Email address:      (redacted)
PostgreSQL version: 12.3
Operating system:   windows 2019
Description:        

When I install PG12 on Windows 10 using the EDB installer, pg_test_fsync
doesn't work.  But I notice Windows 10 is not officially supported, so I
repeated the exercise with EDB installer on a rented box: 
Microsoft Windows Server 2019 with Desktop Experience Locale English AMI
provided by Amazon

And it still doesn't work, see capture from CMD.exe done immediately after
running the EDB installer:

Microsoft Windows [Version 10.0.17763.1282]
(c) 2018 Microsoft Corporation. All rights reserved.

C:\Users\Administrator>"c:\Program
Files\PostgreSQL\12\bin\pg_test_fsync.exe"
5 seconds per test
O_DIRECT supported on this platform for open_datasync and open_sync.

Compare file sync methods using one 8kB write:
(in wal_sync_method preference order, except fdatasync is Linux's default)
        open_datasync                 pg_test_fsync: error: write failed:
Invalid argument

Note that it abandons the run here it does not just report an error and then
continue.
I'm not in a position to compile on Windows, so I can't run git bisect nor
tell if this is something specific to EDB.  But I suspect this rather has
something to do with commit 0ba06e0bfb8cfd24ff17aca92aa72245ddd6c4d7

On v11, this does work.  Or at least it runs to completion, I guess the
numbers reported might be bogus, which is why the indicated commit was done.

Messages

DateAuthorSubject
2020-07-03 16:01:46+00PG Bug reporting formBUG #16526: pg_test_fsync in v12 doesn't run in Windows
2020-07-04 01:03:56+00Michael PaquierRe: BUG #16526: pg_test_fsync in v12 doesn't run in Windows
2020-07-07 08:25:49+00Michael PaquierRe: BUG #16526: pg_test_fsync in v12 doesn't run in Windows
2020-07-10 01:53:54+00Michael PaquierRe: BUG #16526: pg_test_fsync in v12 doesn't run in Windows
2020-07-14 00:06:25+00Bruce MomjianRe: BUG #16526: pg_test_fsync in v12 doesn't run in Windows
2020-07-14 03:54:58+00Michael PaquierRe: BUG #16526: pg_test_fsync in v12 doesn't run in Windows
2020-07-14 14:27:00+00Bruce MomjianRe: BUG #16526: pg_test_fsync in v12 doesn't run in Windows
2020-07-15 06:53:56+00Michael PaquierRe: BUG #16526: pg_test_fsync in v12 doesn't run in Windows
2020-07-15 16:26:53+00Bruce MomjianRe: BUG #16526: pg_test_fsync in v12 doesn't run in Windows
2020-07-16 07:19:01+00Michael PaquierRe: BUG #16526: pg_test_fsync in v12 doesn't run in Windows