Re: Fwd: PITR Recovery settings

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Selva manickaraja" <mavles78(at)gmail(dot)com>, <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Fwd: PITR Recovery settings
Date: 2011-03-28 21:33:46
Message-ID: 4D90B86A020000250003BDFD@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Selva manickaraja <mavles78(at)gmail(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Kevin Grittner 2011-03-28 21:48:50 Re: Wal archives building up in slave pg_xlog dir
Previous Message Guillaume Lelarge 2011-03-28 13:48:22 Re: Triggers on system catalog