Re: BUG #16927: Postgres can`t access WAL files
| От | Ярослав Пашинский |
|---|---|
| Тема | Re: BUG #16927: Postgres can`t access WAL files |
| Дата | |
| Msg-id | CADLmTo+e7ndbr4MMme91H2KKieS0nHA4H8ROS2Y2WfDURdr2FQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: BUG #16927: Postgres can`t access WAL files (Andres Freund <andres@anarazel.de>) |
| Ответы |
Re: BUG #16927: Postgres can`t access WAL files
|
| Список | pgsql-bugs |
Hello, sure. Right now I found recent log for one WAL file and here is a output of find links program:
".\FindLinks64.exe "D:\DB_update\PSQL_4\pg_wal\000000010000429E00000077"
Findlinks v1.1 - Locate file hard links
Copyright (C) 2011-2016 Mark Russinovich
Sysinternals - www.sysinternals.com
Error opening d:\db_update\psql_4\pg_wal\000000010000429e00000077:
Access is denied. "
Findlinks v1.1 - Locate file hard links
Copyright (C) 2011-2016 Mark Russinovich
Sysinternals - www.sysinternals.com
Error opening d:\db_update\psql_4\pg_wal\000000010000429e00000077:
Access is denied. "
P.S.: I run program with admin rights.
пт, 19 мар. 2021 г. в 01:51, Andres Freund <andres@anarazel.de>:
Hi,
On 2021-03-18 14:16:21 +0200, Ярослав Пашинский wrote:
> The strange thing is why one server works fine on unpatched binaries while
> the second one requires a patched version to get rid of pg_wal access
> error.
> UPD: just right now on developer server I got an error: "2021-03-18
> 14:11:39.444 EET [892] LOG: could not rename file
> "pg_wal/00000001000009130000006F": Permission denied"
> Will switch to patched binaries and tell you later.
Could you use
https://docs.microsoft.com/en-us/sysinternals/downloads/findlinks on one
of the files that can't be renamed? Or even better, the all the WAL
files?
Greetings,
Andres Freund
В списке pgsql-bugs по дате отправления: