[GENERAL] Recovery.conf and PITR by recovery_target_time

2013-08-09 Thread ascot.m...@gmail.com
Hi, I am trying another way to test PITR: by recovery_target_time. The test machine has the same PG version 9.2.4 and same O/S Ubuntu 12.04 64 bit.All archived WAL files are shipped and saved in /var/pgsql/data/archive, the latest time stamp of them is 2013-08-09 19:30:01, the full hot

Re: [GENERAL] Recovery.conf and PITR by recovery_target_time

2013-08-09 Thread Albe Laurenz
ascot.m...@gmail.com wrote: I am trying another way to test PITR: by recovery_target_time. The test machine has the same PG version 9.2.4 and same O/S Ubuntu 12.04 64 bit.All archived WAL files are shipped and saved in /var/pgsql/data/archive, the latest time stamp of them is

Re: [GENERAL] Recovery.conf and PITR by recovery_target_time

2013-08-09 Thread ascot.m...@gmail.com
hi 16:47:12 SELECT pg_start_backup('hot_backup'); tar cfP the PG data folder SELECT pg_stop_backup(); regards On 9 Aug 2013, at 9:55 PM, Albe Laurenz wrote: ascot.m...@gmail.com wrote: I am trying another way to test PITR: by recovery_target_time. The test machine has the same PG