Re: Fwd: PITR Recovery settings - Mailing list pgsql-admin

From Kevin Grittner
Subject Re: Fwd: PITR Recovery settings
Date
Msg-id 4D90B86A020000250003BDFD@gw.wicourts.gov
Whole thread Raw
In response to Fwd: PITR Recovery settings  (Selva manickaraja <mavles78@gmail.com>)
List pgsql-admin
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

pgsql-admin by date:

Previous
From: Guillaume Lelarge
Date:
Subject: Re: Triggers on system catalog
Next
From: "Kevin Grittner"
Date:
Subject: Re: Wal archives building up in slave pg_xlog dir