omnipitr 1.3.1

This Release
omnipitr 1.3.1
Date
Status
Stable
Latest Stable
omnipitr 1.3.2 —
Other Releases
Abstract
Advanced WAL File / Backup Management Tools
Description
OmniPITR provides a set of tools for managing PITR, including archive_commands, restore_commands, and creating backups from either the master or slave server
Released By
depesz
License
The PostgreSQL License
Resources
Special Files
Tags

Extensions

omnipitr 1.3.1
Advanced WAL File / Backup Management Tools

Documentation

Log
new()
Checksum
run()
Backup
Backup_Slave/Backup_Master *base* state data structure
intro
OmniPITR
CommandPiper
NAME
Restore
run()
todo
OmniPITR
omnipitr-archive
OmniPITR - omnipitr-archive
Archive
Parser/Archvie state data structure
omnipitr-backup-master
OmniPITR - omnipitr-backup-master
Archive_Queue
split_xlog_filename()
Restore
Parser/Restore state data structure
Tools
ext_for_compression()
install
OmniPITR - Installation
Parser
NAME
omnipitr-backup-slave
OmniPITR - omnipitr-backup-slave
Monitor
run()
Check
NAME
Backup
run()
Program
new()
Archive
run()
Master
make_data_archive()
Pidfile
NAME
omnipitr-synch
OmniPITR - omnipitr-synch
Synch
run()
internals
OmniPITR
howto
OmniPITR - how to setup.
omnipitr-backup-cleanup
OmniPITR - omnipitr-backup-cleanup
changes
OmniPITR
Slave
make_data_archive()
Cleanup
run()
omnipitr-cleanup
OmniPITR - omnipitr-cleanup
omnipitr-restore
OmniPITR - omnipitr-restore
Cleanup
run()
omnipitr-monitor
OmniPITR - omnipitr-monitor
ParallelSystem
NAME

README

OmniPITR

OVERVIEW

OmniPITR is a set of scripts to ease setting up WAL replication, and making hot backups from both Master and Slave systems.

This set of scripts has been written to make the operation seamless, secure and as light on resources-usage as possible.

To make it portable, it was written in Perl, but with assumption that it should work on any Perl installation - i.e. no dependencies on non-base Perl modules.

INSTALLATION

/* Simply fetch the directory https://github.com/omniti-labs/omnipitr, and you're done. More details are in doc/install.pod. */

USAGE

There is a set of scripts in bin/ directory. All named omnipitr-* are scripts meant for general usage (others are not really useful unless you'll encounter some problems).

For every one of them you will have documentation in doc/SCRIPT_NAME.pod - for example documentation for omnipitr-archive script is in doc/omnipitr-archive.pod.

Quick list of programs:

  • omnipitr-archive

    This should be used on master server, as archive_command command, setup in postgresql.conf.

  • omnipitr-restore

    This should be used on slave server/servers, as restore_command command in recovery.conf file.

  • omnipitr-master-backup

    Used to make hot backup on master DB server.

  • omnipitr-slave-backup

    Used to make hot backup on slave DB server.

  • omnipitr-monitor

    General script for Nagios/Cacti type of systems - monitoring, graphing. Provides a way to check for replication lag, last backup timestamp, and other metrics.

  • omnipitr-cleanup

    Removes obsolete wal segments from wal archive, when using streaming replication

  • omnipitr-sync

    Send copy of PGDATA to remote locations - even multiple at the same time.

In most of the cases you can simply call the program you want to use with --help option to get brief overview of command line options.

SUPPORT

Currently there is simply mailing list that you can subscribe, and post your questions/problems to.

Maling list page (includes option to subscribe, and view archives) is available here: http://lists.omniti.com/mailman/listinfo/pgtreats-users/

The OmniPITR project is Copyright (c) 2009-2013 OmniTI. All rights reserved.