pg基于时间点的恢复（PITR）

[postgres9.6@db ~]$ psql postgres postgres9.6
Null display is "NULL".
Pager is always used.
Timing is on.
psql (9.6.1)
Type "help" for help.

postgres9.6@[local]:5432 postgres# show wal_level;
 wal_level 
-----------
 replica
(1 row)

Time: 0.270 ms
postgres9.6@[local]:5432 postgres# show archive_mode;
 archive_mode 
--------------
 on
(1 row)

Time: 0.214 ms
postgres9.6@[local]:5432 postgres# show archive_command ;
                                            archive_command                                             
--------------------------------------------------------------------------------------------------------
 DATE=`date +%Y%m%d`;DIR="/home/postgres9.6/arch/$DATE";(test -d $DIR || mkdir -p $DIR)&& cp %p $DIR/%f
(1 row)


Time: 0.188 ms


postgres9.6@[local]:5432 postgres# select version();
                                                 version                                                 
---------------------------------------------------------------------------------------------------------
 PostgreSQL 9.6.1 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.4.7 20120313 (Red Hat 4.4.7-4), 64-bit
(1 row)


Time: 2.709 ms


postgres9.6@[local]:5432 p