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 по дате отправления:

Предыдущее
От: Guillaume Lelarge
Дата:
Сообщение: Re: Triggers on system catalog
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Wal archives building up in slave pg_xlog dir