From: Kevin Grittner <Kevin.Grittner@wicourts.gov>
To: Selva manickaraja <mavles78@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Re: Fwd: PITR Recovery settings
Date: Mon, 28 Mar 2011 16:33:46 -0500
Message-ID: <4D90B86A020000250003BDFD@gw.wicourts.gov> (raw)
In-Reply-To: <AANLkTimN6vpTMoqEYGwEzkJGKDZpdLadofc+DqEYHuNM@mail.gmail.com>
References: <AANLkTikzuWGRQx7W_Mcr6bgJWvGcd-jq-K6me4DyX6OD@mail.gmail.com>
<AANLkTimN6vpTMoqEYGwEzkJGKDZpdLadofc+DqEYHuNM@mail.gmail.com>
Selva manickaraja <mavles78@gmail.com> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: Kevin.Grittner@wicourts.gov, mavles78@gmail.com
Subject: Re: Fwd: PITR Recovery settings
In-Reply-To: <4D90B86A020000250003BDFD@gw.wicourts.gov>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox