NAME

pg_cryobit - Manage PostgreSQL continuous backup

SYNOPSIS

pg_cryobit help|man|checkconfig|archivewal|rotatewal|archivesnapshot|fullarchive [options]

This is pg_cryobit v.02 - Copyright Jerome Eteve 2010-2011

OPTIONS

COMMANDS

checkconfig

Checks the configuration file is correct.

archivewal

Archive a given WAL file using the configured shipper. Requires options --file.

rotatewal

Forces a wal rotation. Checks the rotated file has been shipped. No required options.

archivesnapshot

Take a snapshot archive of the whole database. No required options.

fullarchive

rotatewal and archivesnapshot. Options apply.

COMMANDS OPTIONS

--conf=<file>

Specify configuration file on the command line. Applies to all commands.

--file=<file>

Specify file to handle. Applies to archivewal

--deepclean

Remove anything earlier than the last archivesnapshot. Applies to archivesnapshot

CONFIGURATION

If no --conf option is given, pg_cryobit looks for a pg_cryobit.conf file in the following directories:

- The current directory

- Your HOME directory (HOME is defined)

- Your system /etc directory.

EXAMPLES

Configuration files examples can be found at https://github.com/jeteve/pg_cryobit/tree/master/App-PgCryobit/conf_example

Here's one of them:

## An example configuration file for pg_cryobit
data_directory /path/to/postgresql/data_directory
## This is optional. Will use /tmp/ is not present.
#snapshooter_dir /path/to/where/you/want/your/snapshots/to/be/build
## This is mandatory. pg_cryobit MUST be able to
## connect to your database using this string.
dsn "dbi:Pg:dbname=PGDATABASE;host=PGHOST;port=PGPORT;user=PGUSER;password=PGPASSWORD"
## Valid options include:
##
# Parameter Environment Variable Default
# --------- -------------------- --------------
# dbname PGDATABASE current userid
# host PGHOST localhost
# port PGPORT 5432
# options PGOPTIONS ""
# tty PGTTY ""
# user PGUSER current userid
# password PGPASSWORD ""
## The shipper configuration.
<shipper>
plugin CopyFactory
## This is where you want your backups and wal logs to be saved.
## This MUST be a safe place, like a SAN location.
## This MUST be writable by the user running pg_cryobit
backup_dir /tmp/backupdir/
</shipper>

SEE ALSO

perldoc App::PgCryobit

Copyright 2010-11 by Jerome Eteve.

This is free software; you can redistribute it and/or modify it under the same terms as Perl itself.