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

From: "Zwettler Markus (OIZ)" <Markus(dot)Zwettler(at)zuerich(dot)ch>
To: "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: how can one infer the maximum possible restore time from a WAL file(name) in a backup?
Date: 2022-11-21 12:45:10
Message-ID: 173875f2fb734d46877eecf55ae0682e@zuerich.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ron 2022-11-21 14:08:36 Re: user credentials rejected by pgAdmin right after new install
Previous Message Satalabaha Postgres 2022-11-21 11:28:31 Finding query execution time using \timing and EXPLAIN ANALYZE..