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 sa

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 "20