Postgresql 中文操作指南

Chapter 26. Backup and Restore

Table of Contents

与包含其他所有贵重数据一样,应定期备份 PostgreSQL 数据库。虽然过程至关简单,但对底层技术和假设有一个清晰的了解非常重要。

As with everything that contains valuable data, PostgreSQL databases should be backed up regularly. While the procedure is essentially simple, it is important to have a clear understanding of the underlying techniques and assumptions.

备份 PostgreSQL 数据有三种本质上有所不同的方法:

There are three fundamentally different approaches to backing up PostgreSQL data:

每个都有其优点和缺点;以下部分将依次讨论每个。

Each has its own strengths and weaknesses; each is discussed in turn in the following sections.