Postgres 14.2 Windows can't rename temporary statistics file

From: Ranier Vilela <ranier(dot)vf(at)gmail(dot)com>
To: Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Postgres 14.2 Windows can't rename temporary statistics file
Date: 2022-02-15 00:19:54
Message-ID: CAEudQAovOEM0haC4NbWZaYGW4ESmAE1j6_yr93tS8Xo8i7+54A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

I've reported this issue, but without success in fixing it.
Now I have installed 14.2 and used in development environment, and
the log still reports:
2022-02-13 18:33:20.502 -03 [7976] LOG: could not rename temporary
statistics file "pg_stat_tmp/global.tmp" to "pg_stat_tmp/global.stat":
Permission denied
2022-02-13 19:33:22.648 -03 [7976] LOG: could not rename temporary
statistics file "pg_stat_tmp/global.tmp" to "pg_stat_tmp/global.stat":
Permission denied

This have consequences in performance or stability of the server?

After applying the patch attached, the log does not report this issue
and dir command show this:

C:\postgres\data>dir *.stat /s
O volume na unidade C é hd
O Número de Série do Volume é F470-0E50

Pasta de C:\postgres\data\pg_stat_tmp

14/02/2022 21:15 1.670 db_0.stat
14/02/2022 21:15 12.215 db_25214.stat
14/02/2022 21:15 1.335 global.stat
3 arquivo(s) 15.220 bytes

The point is we can not relies on the "rename" function at Windows Side.
The local installation is made with user with full rights and permissions,
but
Postgres Windows still can't rename correctly.

thoughts?

regards,
Ranier Vilela

Attachment Content-Type Size
force_rename_temp_windows.patch application/octet-stream 1020 bytes

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2022-02-15 00:42:21 Re: support for CREATE MODULE
Previous Message r.takahashi_2@fujitsu.com 2022-02-14 23:52:58 RE: Support escape sequence for cluster_name in postgres_fdw.application_name