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 |
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 |