Selva manickaraja <mavles78@xxxxxxxxx> wrote: > We have successfully implemented a Backup and Recovery process in > our organization and currently testing it out. We took a previous > day backup and tried to restore it to a point in time. > > The database is able to start applying the recovery settings. But > it recovered records past the recovery target date and time give > by at least 30 minutes. > recovery_target_time = '2011-03-23 16:05:00 MYT' My guess would be that this is some sort of problem with time zone configuration or clock settings. Compare those closely between the two machines and see if you can find any differences. -Kevin -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin