Re: BUG #16927: Postgres can`t access WAL files
Michael Paquier <michael@paquier.xyz>
From: Michael Paquier <michael@paquier.xyz>
To: Ярослав Пашинский <yarik97.6@gmail.com>
Cc: Andres Freund <andres@anarazel.de>, Magnus Hagander <magnus@hagander.net>, Tom Lane <tgl@sss.pgh.pa.us>, Postgres bugs <pgsql-bugs@lists.postgresql.org>
Date: 2021-03-24T00:32:01Z
Lists: pgsql-bugs
On Tue, Mar 23, 2021 at 11:49:32AM +0200, Ярослав Пашинский wrote: > The error has completely gone and replication works fine. Glad to hear that. Until 13.3 is out, you could use the binaries I have provided but these have been stripped from most of their build options to make them portable for the tests: no OpenSSL, no ICU, and more things missing. > Your patch definitely works, my 8 prod & dev clusters + 4 > replication slots works fine on 13.2 now. Only one error still > sometimes gets occurred (as I showed > before): "2021-03-23 > 11:44:52.932 EET [9272] LOG: could not rename temporary > statistics file "pg_stat_tmp/global.tmp" to > "pg_stat_tmp/global.stat": Permission denied" > Hope It'll be fixed in the next releases. This one is a separate issue, and I don't think I'll be able to look at that in more details until the commit fest finishes (development of 14 finsihes in two weeks so the activity is high). Is this something new to 13 or did you see that in past version as well on your servers? -- Michael
Commits
-
Fix concurrency issues with WAL segment recycling on Windows
- 78c24e97dd18 13.3 landed
- 909b449e00fc 14.0 landed