1安装pg_rman

pg_rman-1.2.11-1.pg94.rhel6.x86_64.rpm

2配置环境变量

-bash-4.1$ cat .bashrc

export PATH=/usr/pgsql-9.4/bin:/opt/pgsql/bin:$PATH:$HOME/bin

export PGDATA=/var/lib/pgsql/9.4/data

export PGUSER=postgres

export PGPORT=5432

export LD_LIBRARY_PATH=/var/lib/pgsql/9.4:$LD_LIBRARY_PATH

export BACKUP_PATH=/backup

修改postgresql.conf文件

wal_level=archive

archive_mode = on

archive_command = 'test ! -f /arclog/%f && cp %p /arclog/%f

2初始化备份目录：

开始初始化备份目录：pg_rman init -B /backup

当显示：

INFO: ARCLOG_PATH is set to '/arclog'

INFO: SRVLOG_PATH is set to '/opt/pgsql/data/pg_log'

代表备份目录初始化成功。查看pg_rman.ini：cat /backup/pg_rman.ini显示：

ARCLOG_PATH='/arclog'

SRVLOG_PATH='/opt/pgsql/data/pg_log'

至此，pg_rman安装完毕。

修改pg_rman.ini 文件为：

ARCLOG_PATH='/arclog'

SRVLOG_PATH='/opt/pgsql/data/pg_log'

COMPRESS_DATA = YES

KEEP_ARCLOG_FILES = 10

KEEP_ARCLOG_DAYS = 10

KEEP_DATA_GENERATIONS = 3

KEEP_DATA_DAYS = 120

KEEP_SRVLOG_FILES = 10

KEEP_SRVLOG_DAYS = 10

全被脚本

-bash-4.1$ cat in0.sh

#!/bin/bash

export PATH=/usr/pgsql-9.4/bin:/opt/pgsql/bin:$PATH:$HOME/bin

export PGDATA=/var/lib/pgsql/9.4/data

export PGUSER=postgres

export PGPORT=5432

export LD_LIBRARY_PATH=/var/lib/pgsql/9.4:$LD_LIBRARY_PATH

export BACKUP_PATH=/backup

pg_rman backup --backup-mode=full

pg_rman validate

增量脚本

-bash-4.1$ cat in1.sh

#!/bin/bash

export PATH=/usr/pgsql-9.4/bin:/opt/pgsql/bin:$PATH:$HOME/bin

export PGDATA=/var/lib/pgsql/9.4/data

export PGUSER=postgres

export PGPORT=5432

export LD_LIBRARY_PATH=/var/lib/pgsql/9.4:$LD_LIBRARY_PATH

export BACKUP_PATH=/backup

pg_rman backup --backup-mode=incremental --with-serverlog

pg_rman validate

备份归档的脚本

-bash-4.1$ cat in2.sh

#!/bin/bash

export PATH=/usr/pgsql-9.4/bin:/opt/pgsql/bin:$PATH:$HOME/bin

export PGDATA=/var/lib/pgsql/9.4/data

export PGUSER=postgres

export PGPORT=5432

export LD_LIBRARY_PATH=/var/lib/pgsql/9.4:$LD_LIBRARY_PATH

export BACKUP_PATH=/backup

pg_rman backup --backup-mode= archive --with-serverlog

pg_rman validate

-bash-4.1$ crontab -e

10,20,30,40,50 * * * * sh /var/lib/pgsql/in2.sh >> /var/lib/pgsql/in22.log 2>&1

15,30,45 * * * * sh /var/lib/pgsql/in1.sh >> /var/lib/pgsql/in11.log 2>&1

0 0-23 * * * sh /var/lib/pgsql/in0.sh >> /var/lib/pgsql/in00.log 2>&1