========

pg_arman is a backup and recovery manager for PostgreSQL servers able to do

incremental and full backup as well as restore a cluster to a

differential and full backup as well as restore a cluster to a

state defined by a given recovery target. It is designed to perform

periodic backups of an existing PostgreSQL server, combined with WAL

archives to provide a way to recover a server in case of failure of

server because of a reason or another. Itsincremental backup

server because of a reason or another. Itsdifferential backup

facility reduces the amount of data necessary to be taken between

two consecutive backups.

current.tli=get_current_timeline();

if (current.backup_mode==BACKUP_MODE_INCREMENTAL)

if (current.backup_mode==BACKUP_MODE_DIFF_PAGE)

{

pgBackup*prev_backup;

prev_backup=catalog_get_last_data_backup(backup_list,current.tli);

if (prev_backup==NULL)

elog(ERROR_SYSTEM,_("Valid full backup not found for "

"or validate existing one."));

}

files=NULL;

if (current.backup_mode==BACKUP_MODE_INCREMENTAL)

if (current.backup_mode==BACKUP_MODE_DIFF_PAGE)

{

pgBackup*prev_backup;

elog(ERROR_SYSTEM,_("tablespace storage directory doesn't exist: %s"),mp);

if (prev_files!=NULL)

continue;

if (current.backup_mode==BACKUP_MODE_INCREMENTAL)

if (current.backup_mode==BACKUP_MODE_DIFF_PAGE)

current.data_bytes+=file->read_size;

elseif (current.backup_mode==BACKUP_MODE_FULL)

current.data_bytes+=file->size;

if (current.backup_mode==BACKUP_MODE_FULL||

current.backup_mode==BACKUP_MODE_INCREMENTAL)

current.backup_mode==BACKUP_MODE_DIFF_PAGE)

total_read+=current.data_bytes;

if (total_read==0)

}

}

backup_files(constchar*from_root,

constchar*to_root,

if (backup->status==BACKUP_STATUS_OK&&

(backup->backup_mode==BACKUP_MODE_INCREMENTAL||

(backup->backup_mode==BACKUP_MODE_DIFF_PAGE||

backup->backup_mode==BACKUP_MODE_FULL))

returnbackup;

}

pgBackupWriteConfigSection(FILE*out,pgBackup*backup)

{

staticconstchar*modes[]= {"","INCREMENTAL","FULL"};

staticconstchar*modes[]= {"","PAGE","FULL"};

fprintf(out,"# configuration\n");

v++;

len=strlen(v);

if (len>0&&pg_strncasecmp("full",v,len)==0)

if (len>0&&pg_strncasecmp("full",v,strlen("full"))==0)

returnBACKUP_MODE_FULL;

elseif (len>0&&pg_strncasecmp("incremental",v,len)==0)

returnBACKUP_MODE_INCREMENTAL;

elseif (len>0&&pg_strncasecmp("page",v,strlen("page"))==0)

returnBACKUP_MODE_DIFF_PAGE;

elog(ERROR_ARGS,_("invalid backup-mode \"%s\""),value);

join_path_components(to_path,to_root,file->path+strlen(from_root)+1);

blknum=header.block;

if (fseek(out,blknum*BLCKSZ,SEEK_SET)<0)

BACKUP_MODE=INCREMENTAL

BACKUP_MODE=PAGE

COMPRESS_DATA=NO

TIMELINEID=1

command

- Recovery from backup with just one command, with customized targets

to facilitate the use of PITR.

- Support for full andincremental

- Support for full anddifferential backup

- Compression of backup files

- Management of backups with integrated catalog

Backup target can be one of the following types:

- Full backup, backup a whole database cluster.

-Incremental backup, backup only files or pages modified after the last

-Differential backup, backup only files or pages modified after the last

verified backup.

It is recommended to verify backup files as soon as possible after backup.

Unverified backup cannot be used in restore and inincremental backup.

Unverified backup cannot be used in restore and indifferential backup.

=== RESTORE ===

The fields are:

* Start: start time of backup

* Mode: Mode of backup: FULL (full) orINCR (incremental)

* Mode: Mode of backup: FULL (full) orPAGE (page differential)

* Current TLI: current timeline of backup

* Parent TLI: parent timeline of backup

* Time: total time necessary to take this backup

*-b* _BACKUPMODE_ / *--backup-mode*=_BACKUPMODE_::

Specify backup target files. Available options are: "full",

"incremental". Abbreviated forms (prefix match) are also available.

For example, -b f means "full" backup.

"page".

*-Z* / *--compress-data*::

Compress backup files with zlib if specified.

- If there are some unreadable files/directories in data folder of server

WAL directory or archived WAL directory, the backup or restore will fail

depending on the backup mode selected.

-Incremental backup is not able to take necessary files after a database

-Differential backup is not able to take necessary files after a database

creation, so take a full backup once a new database is created.

== DETAILS ==

0

full database backup

CHECKPOINT

incremental database backup

differential database backup

CHECKPOINT

CHECKPOINT

stop DB during running pgbench

-v, --verbose output process information

Backup options:

-b, --backup-mode=MODE full orincremental

-b, --backup-mode=MODE full orpage

-Z, --compress-data compress data backup with zlib

-C, --smooth-checkpoint do smooth checkpoint before backup

--validate validate backup after taking it

Start Mode Current TLI Parent TLI Time Data Status

==========================================================================

2009-06-03 17:05:53 FULL 1 0 0m ---- RUNNING

2009-06-01 17:05:53INCR 1 0 3m 9223PB DONE

2009-06-01 17:05:53PAGE 1 0 3m 9223PB DONE

2009-05-31 17:05:53 FULL 1 0 3m 1242MB DONE

\! pg_arman validate -B ${PWD}/results/sample_backup 2009-05-31 17:05:53 --debug

INFO: validate: 2009-05-31 17:05:53 backup and archive log files by CRC

==========================================================================

2009-06-03 17:05:53 FULL 1 0 0m ---- RUNNING

2009-06-02 17:05:03 FULL 1 0 0m ---- DELETED

2009-06-01 17:05:53INCR 1 0 3m 9223PB CORRUPT

2009-06-01 17:05:53PAGE 1 0 3m 9223PB CORRUPT

2009-05-31 17:05:53 FULL 1 0 3m 1242MB OK

\! pg_arman show 2009-06-01 17:05:53 -A ${PWD}/results/arclog -B ${PWD}/results/sample_backup

# configuration

BACKUP_MODE=INCREMENTAL

BACKUP_MODE=PAGE

COMPRESS_DATA=false

# result

TIMELINEID=1

printf(_(" -c, --check show what would have been done\n"));

printf(_(" -v, --verbose output process information\n"));

printf(_("\nBackup options:\n"));

printf(_(" -b, --backup-mode=MODE full orincremental\n"));

printf(_(" -b, --backup-mode=MODE full orpage\n"));

printf(_(" -Z, --compress-data compress data backup with zlib\n"));

printf(_(" -C, --smooth-checkpoint do smooth checkpoint before backup\n"));

printf(_(" --validate validate backup after taking it\n"));