TE
科技回声
首页24小时热榜最新最佳问答展示工作
GitHubTwitter
首页

科技回声

基于 Next.js 构建的科技新闻平台,提供全球科技新闻和讨论内容。

GitHubTwitter

首页

首页最新最佳问答展示工作

资源链接

HackerNews API原版 HackerNewsNext.js

© 2025 科技回声. 版权所有。

PostgreSQL adds support for incremental backups

3 点作者 samaysharma超过 1 年前

1 comment

rbmlabs超过 1 年前
This may seem like a good idea, but I&#x27;ve followed some discussions where it became clear it might not be the case. The misuse of this feature could actually be dangerous.<p>It&#x27;s not really &quot;support for incremental backups&quot; as much as &quot;within pg_basebackup&quot;. Other backup tools (such as pgBackRest) have had incremental backup support for quite some time, and more reliably, without this code.<p>I&#x27;m relaying information from others who are very knowledgeable about this. There are gotchas to this new feature:<p>- The filesystem has to POSIX compliant - In order to rebuild the incrementals, they <i>all</i> need to be present in directories - The feature adds no notion of a block structure, so each incremental must be laid on serially<p>It&#x27;s unclear how useful this will be unless used by some very specific external tool that takes advantage of it.<p>Again, tools like pgBackRest has had incremental backup support for quite some time.