how can one infer the maximum possible restore time from a WAL file(name) in a backup?

Поиск
Список
Период
Сортировка
От Zwettler Markus (OIZ)
Тема how can one infer the maximum possible restore time from a WAL file(name) in a backup?
Дата
Msg-id 173875f2fb734d46877eecf55ae0682e@zuerich.ch
обсуждение исходный текст
Ответы Re: how can one infer the maximum possible restore time from a WAL file(name) in a backup?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
Дерево обсуждения

Hi,

 

In Oracle there is a view v$archived_log in which for each logfile the time of the first and last transaction contained in it is indicated. By means of this view one can infer from a log file in the backup the maximum possible recovery time.

 

Is there something similar in Postgres? Or in other words, how can one infer the maximum possible restore time from a WAL file(name) in a backup?

 

Thanks, Markus

 

 

В списке pgsql-admin по дате отправления:

Предыдущее
От: Satalabaha Postgres
Дата:
Сообщение: Finding query execution time using \timing and EXPLAIN ANALYZE..
Следующее
От: Ron
Дата:
Сообщение: Re: user credentials rejected by pgAdmin right after new install