-bash-4.1$ pg_rman backup --backup-mode=full
INFO: database backup start
NOTICE: pg_stop_backup complete, all required WAL segments have been archived
-bash-4.1$ pg_rman backup --backup-mode=incremental --with-serverlog
INFO: database backup start
ERROR: There is no validated full backup with current timeline.Please take a full backup and validate it before doing an incremental backup.
NOTICE: pg_stop_backup complete, all required WAL segments have been archived
-bash-4.1$ pg_rman backup --backup-mode=archive --with-serverlog
-bash-4.1$ pg_rman show -a
============================================================================
Start Time Total Data WAL Log Backup Status
============================================================================
2015-06-25 03:05:12 0m ---- ---- 301MB 1733B 488kB DONE
2015-06-25 03:02:04 0m ---- 0B ---- ---- 0B ERROR
2015-06-25 02:59:24 1m 411MB ---- 251MB ---- 33MB DONE
2015-06-25 02:42:26 0m ---- ---- 184MB 2047B 299kB DONE
2015-06-25 02:41:00 0m ---- 0B ---- ---- 0B ERROR
2015-06-25 02:37:36 0m 411MB ---- 134MB ---- 32MB OK
2015-06-25 01:25:22 0m ---- ---- 33MB 0B 53kB OK
2015-06-25 01:25:11 0m ---- ---- 16MB 0B 27kB OK
2015-06-25 01:04:24 0m ---- 16kB 33MB 3842B 58kB OK
2015-06-25 00:59:10 0m 411MB ---- 251MB ---- 33MB OK
2015-06-24 23:18:39 14m 2059MB ---- 167MB ---- 163MB OK
2015-06-24 05:29:11 ---- ---- ---- ---- ---- 0B ERROR
2015-06-24 04:01:40 0m ---- 411MB 117MB ---- 30MB OK
2015-06-24 03:52:59 1m 411MB ---- 83MB ---- 32MB OK
2015-06-24 02:56:44 0m ---- 16kB 33MB 189kB 245kB OK
2015-06-24 02:51:55 0m 411MB ---- 33MB ---- 32MB OK
-bash-4.1$ pg_ctl stop
waiting for server to shut down.... done
server stopped
-bash-4.1$ ls
postgresql-Thu.log
-bash-4.1$ cd ..
-bash-4.1$ ls
backup_label.bak2 global pg_ident.conf pg_notify pg_stat_tmp pg_xlog recovery.conf.bal
backup_label.old logfile pg_log pg_replslot pg_subtrans postgresql.auto.conf recovery.done
base pg_clog pg_log.bak pg_serial pg_tblspc postgresql.conf
data.bak pg_dynshmem pg_logical pg_snapshots pg_twophase postmaster.opts
data_bak_15.47 pg_hba.conf pg_multixact pg_stat PG_VERSION recovery.conf.bak
-bash-4.1$ cd ..
-bash-4.1$ ls
backups backup.tar backup.tar.bak data data_000 data_1bak databak2 datadrop datastop_bak logfile pgstartup.log
-bash-4.1$ mv data data1515
-bash-4.1$ pg_rman restore --recover-target-time "2015-06-25 03:05:12"
pg_rman: unrecognized option '--recover-target-time'
Try "pg_rman --help" for more information.
-bash-4.1$ pg_rman restore --recovery-target-time "2015-06-25 03:05:12"
WARNING: can't open pg_controldata file "/var/lib/pgsql/9.4/data/global/pg_control": No such file or directory
WARNING: can't open pg_controldata file "/var/lib/pgsql/9.4/data/global/pg_control": No such file or directory
INFO: validate: 2015-06-25 02:59:24 backup and archive log files by SIZE
INFO: restore complete. Recovery starts automatically when the PostgreSQL server is started.
-bash-4.1$ psql
psql: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
-bash-4.1$ pg_ctl start
server starting
-bash-4.1$ < 2015-06-25 03:16:20.762 EDT >LOG: redirecting log output to logging collector process
< 2015-06-25 03:16:20.762 EDT >HINT: Future log output will appear in directory "pg_log".
-bash-4.1$ psql
psql (9.4.3)
Type "help" for help.
postgres=# \q
-bash-4.1$ psql arch
psql (9.4.3)
Type "help" for help.
arch=# select * from test
arch-# select * from test;
ERROR: syntax error at or near "select"
LINE 2: select * from test;
^
arch=# select * from test;
a
---
1
2
3
4
(4 rows)
-bash-4.1$ cat recovery.done
# recovery.conf generated by pg_rman 1.2.11
restore_command = 'cp /arclog/%f %p'
recovery_target_time = '2015-06-25 03:05:12'
recovery_target_timeline = '5'
-bash-4.1$ ls
backup_label.bak2 global pg_ident.conf pg_notify pg_stat_tmp pg_xlog recovery.conf.bak
backup_label.old logfile pg_log pg_replslot pg_subtrans postgresql.auto.conf recovery.conf.bal
base pg_clog pg_log.bak pg_serial pg_tblspc postgresql.conf recovery.done
data.bak pg_dynshmem pg_logical pg_snapshots pg_twophase postmaster.opts
data_bak_15.47 pg_hba.conf pg_multixact pg_stat PG_VERSION postmaster.pid
-bash-4.1$ cd pg_log
-bash-4.1$ ls
postgresql-Thu.log
-bash-4.1$ cat postgresql-Thu.log
< 2015-06-25 03:16:20.763 EDT >LOG: database system was interrupted; last known up at 2015-06-25 02:59:24 EDT
< 2015-06-25 03:16:20.873 EDT >LOG: restored log file "00000005.history" from archive
< 2015-06-25 03:16:20.873 EDT >LOG: starting point-in-time recovery to 2015-06-25 03:05:12-04
< 2015-06-25 03:16:20.875 EDT >LOG: restored log file "00000005.history" from archive
< 2015-06-25 03:16:20.895 EDT >LOG: restored log file "00000005000000000000005A" from archive
< 2015-06-25 03:16:20.930 EDT >LOG: redo starts at 0/5A000090
< 2015-06-25 03:16:20.930 EDT >LOG: consistent recovery state reached at 0/5A0000B8
< 2015-06-25 03:16:20.952 EDT >LOG: restored log file "00000005000000000000005B" from archive
< 2015-06-25 03:16:20.975 EDT >LOG: restored log file "00000005000000000000005C" from archive
< 2015-06-25 03:16:20.996 EDT >LOG: restored log file "00000005000000000000005D" from archive
< 2015-06-25 03:16:21.019 EDT >LOG: restored log file "00000005000000000000005E" from archive
< 2015-06-25 03:16:21.019 EDT >LOG: recovery stopping before commit of transaction 1972, time 2015-06-25 03:05:13.065482-04
< 2015-06-25 03:16:21.019 EDT >LOG: redo done at 0/5E000028
< 2015-06-25 03:16:21.019 EDT >LOG: last completed transaction was at log time 2015-06-25 03:02:23.487597-04
< 2015-06-25 03:16:21.043 EDT >LOG: restored log file "00000005000000000000005D" from archive
cp: cannot stat `/arclog/00000006.history': No such file or directory
< 2015-06-25 03:16:21.047 EDT >LOG: selected new timeline ID: 6
< 2015-06-25 03:16:21.049 EDT >LOG: restored log file "00000005.history" from archive
< 2015-06-25 03:16:21.112 EDT >LOG: archive recovery complete
< 2015-06-25 03:16:21.316 EDT >LOG: database system is ready to accept connections
< 2015-06-25 03:16:21.317 EDT >LOG: autovacuum launcher started
< 2015-06-25 03:17:12.794 EDT >ERROR: syntax error at or near "select" at character 20
< 2015-06-25 03:17:12.794 EDT >STATEMENT: select * from test
select * from test;
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/29898569/viewspace-1274723/
,如需转载,请注明出处,否则将追究法律责任。