Re: Intermittent pg_ctl failures on Windows

r.zharkov@postgrespro.ru

View thread View on postgr.es

From: Жарков Роман <r.zharkov@postgrespro.ru>

To: Michael Paquier <michael@paquier.xyz>

Cc: Tom Lane <tgl@sss.pgh.pa.us>, Badrul Chowdhury <bachow@microsoft.com>, pgsql-hackers@lists.postgresql.org

Date: 2019-07-18T07:04:34Z

Lists: pgsql-hackers

Attachments

image1.png (image/png)
(unnamed) (text/plain)

Hello,

Therefore, we suggest replace the deletion of a lock file by renaming it.
unlink in windows is not an atomic operation.
When we try to open the file between 
SetDispositionInformationFile and CloseFile we get ERROR_DELETE_PENDING ( see screenshot )

Commits

Allow concurrent-safe open() and fopen() in frontend code for Windows
- f02259fe93e7 11.0 landed
- 0ba06e0bfb8c 12.0 landed
Change pg_ctl to detect server-ready by watching status in postmaster.pid.
- f13ea95f9e47 10.0 cited