Re: Fwd: PITR Recovery settings

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: Fwd: PITR Recovery settings
Дата
Msg-id 4D90B86A020000250003BDFD@gw.wicourts.gov
обсуждение исходный текст
Ответ на Fwd: PITR Recovery settings  (Selva manickaraja <mavles78@gmail.com>)
Список 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 по дате отправления: