pg_rman is an online backup and restore tool for PostgreSQL.

The goal of the pg_rman project is providing a method for online backup and PITR as easy as pg_dump. Also, it maintains a backup catalog per database cluster. Users can maintain old backups including archive logs with one command.

pg_rman プロジェクトが目指すのは、オンライン・バックアップやリストア (PITR) を、pg_dump 並に簡単な操作で実現することです。また、このツールはデータベースごとのバックアップ・カタログを管理しており、バックアップやアーカイブログのメンテナンスを簡単なコマンドで行うことができます。

News

• 2012-05-18 : pg_rman 1.2.4 is released. This supports for backups from standby.
• 2011-12-27 : pg_rman 1.2.3 is released. Fix build problem on RHEL6.
• 2011-11-28 : pg_rman 1.2.2 is released. This supports for PostgreSQL 9.1 and fixed some bugs. details are on Google Groups for pg_rman.
• 2011-06-21 : pg_rman 1.2.1 is released. Fix --keep-arclog-files and --keep-arclog-days options does not work with PostgreSQL 9.0. And revise this page(add Google Groups for pg_rman).

Documentation

• English
• Japanese (ドキュメント)

Features

• Ease of use. Backup and restore can be done with just one command.
• Online full backup, incremental backup, and archive backup. Incremental backup can reduce backup size extreamly.
• Backup compression. Unused area in pages are removed and only actual data are compressed with gzip.
• Automatic backup maintenance. Backup and archive WAL files older than specified days are deleted automatically.
• Backup validation. Backup can be validated with CRC checks.
• No transaction lost in restore. Configuration file generator for point-in-time recovery is supported.

System Configuration

• English
• Japanese (システム構成)

Miscellaneous

• List of Tested Platforms (テスト済みの環境一覧)