立即与支持人员聊天
与支持团队交流

NetVault Plug-in for PostgreSQL 12.3.1 - User Guide

Introducing NetVault Backup Plug-in for PostgreSQL Installing and removing the plug-in Configuring the plug-in Backing up data Restoring data Troubleshooting

Backing up data

IMPORTANT: On Windows, use appropriate encoding during database cluster initialization; that is, when you run initdb. Backups fail if you use UTF-8 encoding and the database or table names contain non-ASCII characters.

Defining a backup strategy

Before commencing with database backups, ensure that you have a backup strategy that safeguards data against media failure, data corruption, user error, and loss of the database server. The following topics provide information that helps you devise a backup strategy for use with Plug‑in for PostgreSQL.

Reviewing the available backup methods

The plug-in offers the following backup methods:

SQL Logical Data Dump: Selecting this method performs logical data dumps composed of SQL commands that are used to reconstruct the PostgreSQL data. The PostgreSQL Server utilities pg_dump and pg_dumpall are used to perform SQL Logical Data Dump Backups. This option supports database-cluster backups and individual database and table backups in different backup formats.
File Level Data Copy: If you are using PostgreSQL Server 9.6 or later, this option supports archive-based backups and restores of the complete PostgreSQL database cluster. This option performs a physical backup of the PostgreSQL Server data files and works in combination with the pg_start_backup and pg_stop_backup utilities.

Supported backup formats for the SQL Logical Data Dump backup method

The plug-in supports backups in Plain-text SQL Script File, TAR Archive, and Custom Archive (Linux only) backup formats, which can be used to back up an entire database cluster or individual databases and tables.

Plain-text SQL Script File: This format generates a plain-text file that contains the SQL commands required to reconstruct the database to the state it was in at the time of backup.
TAR Archive File: This format generates a tape archive (TAR) file that is not compressed.
Custom Archive File (Linux only): This format generates an archive file that is compressed by default. It lets you select the compression level and can be used for tables that are larger than the maximum file size supported by the OS.
The custom archive format requires the zlib compression library and can be used only on PostgreSQL installations built with this library. This library is included by default during PostgreSQL installation unless you use the ‑‑without‑zlib option to disable support for Custom Archive.

While similar backup options are available with all three formats, there are minor differences. All three formats let you restore only what is needed and restore data to a different cluster or server.

相关文档

The document was helpful.

选择评级

I easily found the information I needed.

选择评级