How to PITR Postgres

Options --> Recovery.conf 

recovery_target_time = '2019-11-15 16:00:00+07' 

restore_command = 'cp /data/archive/%f %p'

Settings in the recovery.conf file: restore_command(string) 

Unix: 

restore_command = 'cp /mnt/server/archivedir/%f "%p"’ 

recovery_target_name (string) (select pg_create_restore_point(’Name'); 

recovery_target_time(timestamp) 

recovery_target_xid(string) 

recovery_target_inclusive(boolean) 

pause_at_recovery_target (boolean) 

recovery_target ‘immediate’