資料庫的備份還原機制是必須的,但是總不可能在每個時段做全備份的動作,所以當資料庫必須回復到某一個時間點時,就必須借助PITR(Point-In-Time-Recovery)功能,PITR在PostgreSQL或EDB都是內建功能,以下就來驗證PITR功能:
#mkdir -p /tmp/backup
#mkdir -p /tmp/archive
#chown -R enterprisedb.enterprisedb /tmp/backup
#chown -R enterprisedb.enterprisedb /tmp/archive
wal_level = archive
archive_mode = on
archive_command = ‘test ! -f /tmp/archive/%f && cp %p /tmp/archive/%f’
#service ppas-9.4 restart
#edb-psql -U labuser test
edb=#create table lab_table(id number,col varchar2(100));
edb=#\q
$pg_basebackup -D /tmp/backup -Ft -z -U enterprisedb -p 5444
edb=#select now();
edb=#insert into lab_table values (generate_series(1,100),’###’);
edb=#select now();
restore_command = ‘cp /tmp/archive/%f %p’
recovery_target_time = ‘2015-01-01 00:00:00
10.完成