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  (Michael Paquier <michael@paquier.xyz>)
Список 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. "
 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 по дате отправления:

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: BUG #16927: Postgres can`t access WAL files
Следующее
От: Ярослав Пашинский
Дата:
Сообщение: Re: BUG #16927: Postgres can`t access WAL files