GitPlanet

Cheap and reliable Node.js hosting starts at $3/month, and $1/month static HTML hosting

Created with love in Canada, visit hostnodejs.com today

Feel like to post an Ad? Learn Details
All Projects → ossc-db → Pg_rman

ossc-db / Pg_rman

Licence: other
Backup and restore management tool for PostgreSQL

Programming Languages

c
50402 projects - #5 most used programming language

Labels

postgresqlbackuprestore

Projects that are alternatives of or similar to Pg rman

Pitrery
PostgreSQL Point In Time Recovery made easy
Stars: ✭ 99 (-49.75%)
Mutual labels:  postgresql, backup, restore
Bareos
Main repository with the code for the libraries and daemons
Stars: ✭ 651 (+230.46%)
Mutual labels:  postgresql, backup, restore
Backup Manager
Database backup manager for dumping to and restoring databases from S3, Dropbox, FTP, SFTP, and Rackspace Cloud
Stars: ✭ 1,589 (+706.6%)
Mutual labels:  postgresql, backup, restore
Pgbackrest
Reliable PostgreSQL Backup & Restore
Stars: ✭ 766 (+288.83%)
Mutual labels:  postgresql, backup, restore
Pg probackup
Backup and recovery manager for PostgreSQL
Stars: ✭ 383 (+94.42%)
Mutual labels:  postgresql, backup, restore
Pghoard
PostgreSQL backup and restore service
Stars: ✭ 1,027 (+421.32%)
Mutual labels:  postgresql, backup, restore
Etcd Backup Restore
Collection of components to backup and restore the Etcd of a Kubernetes cluster
Stars: ✭ 99 (-49.75%)
Mutual labels:  backup, restore
Zmbackup
A reliable software written in Shell Script to help you in your daily task to backup and restore mails and accounts from Zimbra Open Source Email Platform. Project in deprecation process. Please help me with Waddles.
Stars: ✭ 103 (-47.72%)
Mutual labels:  backup, restore
Conserve
[beta] robust portable backup tool in Rust
Stars: ✭ 107 (-45.69%)
Mutual labels:  backup, restore
Nextcloud Backup Restore
Moved to codeberg.org - https://codeberg.org/DecaTec/Nextcloud-Backup-Restore - Bash scripts for backup/restore of Nextcloud
Stars: ✭ 115 (-41.62%)
Mutual labels:  backup, restore
Cv4pve Barc
Backup And Restore Ceph for Proxmox VE
Stars: ✭ 74 (-62.44%)
Mutual labels:  backup, restore
Helicopterizer
Backup and Restore for Docker Container!
Stars: ✭ 112 (-43.15%)
Mutual labels:  backup, restore
Backy2
backy2: Deduplicating block based backup software for ceph/rbd, image files and devices
Stars: ✭ 126 (-36.04%)
Mutual labels:  postgresql, backup
Agent
The best way to backup and restore your database
Stars: ✭ 80 (-59.39%)
Mutual labels:  postgresql, backup
Bareos Webui
Bareos Web User Interface
Stars: ✭ 78 (-60.41%)
Mutual labels:  backup, restore
Rdiffweb
A simplified backup management software for quick access to your archives through an efficient web interface.
Stars: ✭ 76 (-61.42%)
Mutual labels:  backup, restore
Pg extractor
PG Extractor - Advanced PostgreSQL Dump Filter
Stars: ✭ 139 (-29.44%)
Mutual labels:  postgresql, backup
Wal G
Archival and Restoration for Postgres
Stars: ✭ 1,974 (+902.03%)
Mutual labels:  postgresql, backup
Cognito Backup Restore
AIO Tool for backing up and restoring AWS Cognito User Pools
Stars: ✭ 142 (-27.92%)
Mutual labels:  backup, restore
Knoxite
A data storage & backup system
Stars: ✭ 165 (-16.24%)
Mutual labels:  backup, restore
View All Similar Projects ➔

pg_rman

pg_rman is an online backup and restore tool for PostgreSQL.

The goal of the pg_rman project is to provide a method for online backup and PITR that is 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.

Branches

There are several branches within pg_rman repository in order to work with different PostgreSQL server versions without introducing server version check code blocks. Please choose a branch to match the PostgreSQL version you will be building pg_rman against.

  • master : branch for latest PostgreSQL development version Build Status
  • REL_13_STABLE : branch for PostgreSQL 13.0 Build Status
  • REL_12_STABLE : branch for PostgreSQL 12.0 Build Status
  • REL_11_STABLE : branch for PostgreSQL 11.0 Build Status
  • REL_10_STABLE : branch for PostgreSQL 10.0 Build Status
  • REL9_6_STABLE : branch for PostgreSQL 9.6 Build Status
  • REL9_5_STABLE : branch for PostgreSQL 9.5 Build Status

How to use

To take an online backup, use the backup command:

$ pg_rman backup --backup-mode=full --with-serverlog
INFO: copying database files
INFO: copying archived WAL files
INFO: copying server log files
INFO: backup complete
INFO: Please execute 'pg_rman validate' to verify the files are correctly copied.

To list all the backups taken so far, use the show command:

$ pg_rman show
 =====================================================================
 StartTime            EndTime              Mode    Size   TLI  Status
 =====================================================================
 2015-03-27 14:59:47  2015-03-27 14:59:49  FULL  3404kB     3  OK
 2015-03-27 14:59:19  2015-03-27 14:59:20  ARCH    26kB     3  OK
 2015-03-27 14:59:00  2015-03-27 14:59:01  ARCH    26kB     3  OK
 2015-03-27 14:58:46  2015-03-27 14:58:48  FULL  3516kB     3  OK
 2015-03-27 11:43:31  2015-03-27 11:43:32  INCR    54kB     1  OK
 2015-03-27 11:43:19  2015-03-27 11:43:20  INCR    69kB     1  OK
 2015-03-27 11:43:04  2015-03-27 11:43:05  INCR   151kB     1  OK
 2015-03-27 11:42:56  2015-03-27 11:42:56  INCR    96kB     1  OK
 2015-03-27 11:34:55  2015-03-27 11:34:58  FULL  5312kB     1  OK

To restore from a backup, use the restore command. Up to PostgreSQL11, note that pg_rman itself generates the recovery.conf file required to perform PostgreSQL PITR.

$ pg_ctl stop -m immediate
$ pg_rman restore
$ cat $PGDATA/recovery.conf
# recovery.conf generated by pg_rman 1.3.11
restore_command = 'cp /home/postgres/arclog/%f %p'
recovery_target_timeline = '1'
$ pg_ctl start

After to PostgreSQL12, note that pg_rman itself added PostgreSQL PITR related options to postgresql.conf file and generates the recovery.signal file in sub directory of PGBASE

To see more options to use with each command, run pg_rman --help.

Also, see the documentation for detailed usage:

http://ossc-db.github.io/pg_rman/index.html

How to build and install from source code

Go to the top directory of pg_rman source tree and run the following commands:

 $ make
 # make install

The following packages need to be installed as a prerequisite.

  • zlib-devel

How to run regression tests

Start PostgreSQL server and run the below command.

 $ make installcheck
Note that the project description data, including the texts, logos, images, and/or trademarks, for each open source project belongs to its rightful owner. If you wish to add or remove any projects, please contact us at [email protected].