Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 8864A1337BDD for ; Mon, 28 Mar 2011 18:34:01 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 65426-06 for ; Mon, 28 Mar 2011 21:33:54 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from gw.wicourts.gov (gwmta.wicourts.gov [165.219.244.99]) by mail.postgresql.org (Postfix) with ESMTP id ED0221337BDB for ; Mon, 28 Mar 2011 18:33:53 -0300 (ADT) Received: from Courts-MTA by gw.wicourts.gov with Novell_GroupWise; Mon, 28 Mar 2011 16:33:53 -0500 Message-Id: <4D90B86A020000250003BDFD@gw.wicourts.gov> X-Mailer: Novell GroupWise Internet Agent 8.0.1 Date: Mon, 28 Mar 2011 16:33:46 -0500 From: "Kevin Grittner" To: "Selva manickaraja" , Subject: Re: Fwd: PITR Recovery settings References: In-Reply-To: Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-10 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201103/254 X-Sequence-Number: 37126 Selva manickaraja 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