POSTGRESQL9.5之pg_rman工具

[postgres@sdserver40_210 ~]$ pg_rman backup --backup-mode=full --progressINFO: copying database filesProcessed of files, skippedNOTICE: pg_stop_backup complete, all required WAL segments have been archivedINFO: copying archived WAL filesProcessed of files, skippedINFO: backup completeHINT: Please execute 'pg_rman validate' to verify the files are correctly copied.

[postgres@sdserver40_210 ~]$ pg_rman show========================================================== StartTime Mode Duration Size TLI Status==========================================================-- :: FULL 0m 343MB DONE[postgres@sdserver40_210 ~]$ pg_rman validateINFO: validate: "2016-05-31 16:36:45" backup and archive log files by CRCINFO: backup "2016-05-31 16:36:45" is valid[postgres@sdserver40_210 ~]$ pg_rman show========================================================== StartTime Mode Duration Size TLI Status==========================================================-- :: FULL 0m 343MB OK

[postgres@sdserver40_210 ~]$ lltotaldrwxrwxr-x postgres postgres May : archivedrwxrwxr-x postgres postgres May : backupdrwx------ postgres postgres May : datadrwxrwxr-x postgres postgres May : log-rw-rw-r-- postgres postgres May : out_file-rw-rw-r-- postgres postgres May : out.txtdrwxrwxr-x postgres postgres May : scripts-rw-r--r-- postgres postgres May : test.sql[postgres@sdserver40_210 ~]$ rm -rf data[postgres@sdserver40_210 ~]$ lltotaldrwxrwxr-x postgres postgres May : archivedrwxrwxr-x postgres postgres May : backupdrwxrwxr-x postgres postgres May : log-rw-rw-r-- postgres postgres May : out_file-rw-rw-r-- postgres postgres May : out.txtdrwxrwxr-x postgres postgres May : scripts-rw-r--r-- postgres postgres May : test.sql[postgres@sdserver40_210 ~]$ pg_stopwaiting for server to shut down.... doneserver stopped[postgres@sdserver40_210 ~]$ pg_rman restore --recovery-target-time "2016-05-31 17:30:00"INFO: the recovery target timeline ID is not givenINFO: use timeline ID of current database clusterINFO: calculating timeline branches to be used to recovery target pointINFO: searching latest full backup which can be used as restore start pointINFO: found the full backup can be used as base in recovery: "2016-05-31 16:36:45"INFO: copying online WAL files and server log filesINFO: clearing restore destinationINFO: validate: "2016-05-31 16:36:45" backup and archive log files by SIZEINFO: backup "2016-05-31 16:36:45" is validINFO: restoring database files from the full mode backup "2016-05-31 16:36:45"INFO: searching incremental backup to be restoredINFO: searching backup which contained archived WAL files to be restoredINFO: backup "2016-05-31 16:36:45" is validINFO: restoring WAL files from backup "2016-05-31 16:36:45"INFO: restoring online WAL files and server log filesINFO: generating recovery.confINFO: restore completeHINT: Recovery will start automatically when the PostgreSQL server is started.[postgres@sdserver40_210 ~]$ pg_startserver starting[postgres@sdserver40_210 ~]$ psql mydb lottupsql ()Type "help" for help.mydb=> \d List of relations Schema | Name | Type | Owner--------+------+-------+------- public | test | table | lottu( row)mydb=> select * from test; id | name------+-------- | lottu | rax | xuan | li0924( rows)mydb=> \q[postgres@sdserver40_210 ~]$ lltotaldrwxrwxr-x postgres postgres May : archivedrwxrwxr-x postgres postgres May : backupdrwx------ postgres postgres May : datadrwxrwxr-x postgres postgres May : log-rw-rw-r-- postgres postgres May : out_file-rw-rw-r-- postgres postgres May : out.txtdrwxrwxr-x postgres postgres May : scripts-rw-r--r-- postgres postgres May : test.sql