The Perl Toolchain Summit needs more sponsors. If your company depends on Perl, please support this very important event.

NAME

pg_cryobit - Manage PostgreSQL continuous backup

SYNOPSIS

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

This is pg_cryobit v.03 - Copyright Jerome Eteve 2010-2012

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

--quiet

Same as --verbose=ERROR

--verbose=(TRACE|DEBUG|INFO|WARN|ERROR|FATAL)

Sets the verbosity level. Default is INFO. You probably want to avoid using FATAL only.

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.