Hi!
Postgres 13.1 is installed in windows server. There are about 100 users.
Log files contain huge number of permisson denied error messages in
every day like :
2021-03-04 01:38:49.818 EET [4580] LOG: could not rename file
"pg_wal/00000001000000050000001B": Permission denied
2021-03-04 01:48:42.725 EET [4580] LOG: could not rename file
"pg_wal/00000001000000050000001B": Permission denied
2021-03-04 01:53:22.427 EET [4580] LOG: could not rename file
"pg_wal/00000001000000050000001B": Permission denied
2021-03-04 01:58:19.623 EET [4580] LOG: could not rename file
"pg_wal/00000001000000050000001B": Permission denied
2021-03-04 02:03:24.080 EET [4580] LOG: could not rename file
"pg_wal/00000001000000050000001B": Permission denied
2021-03-04 02:43:17.983 EET [7764] LOG: invalid length of startup packet
2021-03-04 02:43:21.634 EET [4580] LOG: could not rename file
"pg_wal/00000001000000050000001B": Permission denied
2021-03-04 02:48:25.048 EET [4580] LOG: could not rename file
"pg_wal/00000001000000050000001B": Permission denied
2021-03-04 02:53:19.229 EET [4580] LOG: could not rename file
"pg_wal/00000001000000050000001B": Permission denied
2021-03-04 02:58:19.176 EET [4580] LOG: could not rename file
"pg_wal/00000001000000050000001B": Permission denied
2021-03-04 03:03:19.136 EET [4580] LOG: could not rename file
"pg_wal/00000001000000050000001B": Permission denied
2021-03-04 03:29:33.926 EET [2460] FATAL: expected SASL response, got
message type 0
2021-03-04 03:36:04.995 EET [4816] LOG: could not rename temporary
statistics file "pg_stat_tmp/global.tmp" to "pg_stat_tmp/global.stat":
Permission denied
2021-03-04 03:36:09.666 EET [10340] LOG: using stale statistics instead
of current ones because stats collector is not responding
2021-03-04 03:53:20.036 EET [4580] LOG: could not rename file
"pg_wal/00000001000000050000001B": Permission denied
2021-03-04 04:03:19.001 EET [4580] LOG: could not rename file
"pg_wal/00000001000000050000001B": Permission denied
On middle of day where usage is intensive those appear exactly after
every 10 seconds:
2021-03-05 12:08:40.001 EET [4580] LOG: could not rename file
"pg_wal/000000010000000500000078": Permission denied
2021-03-05 12:08:50.059 EET [4580] LOG: could not rename file
"pg_wal/00000001000000050000007D": Permission denied
2021-03-05 12:09:00.115 EET [4580] LOG: could not rename file
"pg_wal/000000010000000500000082": Permission denied
2021-03-05 12:09:10.171 EET [4580] LOG: could not rename file
"pg_wal/000000010000000500000088": Permission denied
2021-03-05 12:09:20.224 EET [4580] LOG: could not rename file
"pg_wal/0000000100000005000000A4": Permission denied
2021-03-05 12:09:30.281 EET [4580] LOG: could not rename file
"pg_wal/0000000100000005000000A8": Permission denied
2021-03-05 12:09:40.339 EET [4580] LOG: could not rename file
"pg_wal/0000000100000005000000B0": Permission denied
2021-03-05 12:09:50.397 EET [4580] LOG: could not rename file
"pg_wal/0000000100000005000000E7": Permission denied
2021-03-05 12:10:00.456 EET [4580] LOG: could not rename file
"pg_wal/0000000100000005000000E8": Permission denied
2021-03-05 12:10:10.514 EET [4580] LOG: could not rename file
"pg_wal/0000000100000005000000E9": Permission denied
2021-03-05 12:10:20.570 EET [4580] LOG: could not rename file
"pg_wal/0000000100000005000000EB": Permission denied
2021-03-05 12:10:30.626 EET [4580] LOG: could not rename file
"pg_wal/0000000100000005000000EC": Permission denied
How to fix this ?
It looks like database is working normally, users havent reported any
issues.
Andrus.
