Postgresql 13日志:无法重命名文件"pg_wal/0000000100000001000000C6“
Postgresql 13日志:无法重命名文件"pg_wal/0000000100000001000000C6“
提问于 2020-12-22 16:36:14
在我的postgresql日志文件中出现了一些非常奇怪的东西。我把postgresql的版本从13.0更新到了13.1，这也是一样的：
2020-12-21 15:17:55.652 EET [4316] LOG: starting PostgreSQL 13.1, compiled by Visual C++ build 1914, 64-bit
2020-12-21 15:17:55.657 EET [4316] LOG: listening on IPv6 address "::", port 5432
2020-12-21 15:17:55.660 EET [4316] LOG: listening on IPv4 address "0.0.0.0", port 5432
2020-12-21 15:17:55.998 EET [5224] LOG: database system was shut down at 2020-12-21 15:17:01 EET
2020-12-21 15:17:56.075 EET [4316] LOG: database system is ready to accept connections
2020-12-21 16:43:14.938 EET [7832] LOG: could not rename file "pg_wal/0000000100000001000000C6": Permission denied
2020-12-21 16:48:17.949 EET [7832] LOG: could not rename file "pg_wal/0000000100000001000000C6": Permission denied
2020-12-21 16:53:15.911 EET [7832] LOG: could not rename file "pg_wal/0000000100000001000000C6": Permission denied
2020-12-21 16:58:14.865 EET [7832] LOG: could not rename file "pg_wal/0000000100000001000000C6": Permission denied
2020-12-21 17:03:14.730 EET [7832] LOG: could not rename file "pg_wal/0000000100000001000000C6": Permission denied找不到关于那条消息的任何东西。重新启动服务后，一段时间后，该消息开始每隔5分钟显示一次。我知道这是因为checkpoint_timeout = 5min，但这就是我所知道的。有人来帮我吗？
回答 1
Stack Overflow用户
发布于 2020-12-22 16:42:42
可能是某个人或某物锁定或修改了此文件的权限。也许是防病毒软件(应该总是防止它扰乱数据目录)。
但是也有一个bug in PostgreSQL导致了这个问题。此错误已通过PostgreSQL 13.3和v14或更好版本中的提交909b449e00fc修复(此错误是在v13中引入的)。
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/65405479
复制相关文章
相似问题
腾讯云开发者
