Thread: how can one infer the maximum possible restore time from a WAL file(name) in a backup?
how can one infer the maximum possible restore time from a WAL file(name) in a backup?
From
"Zwettler Markus (OIZ)"
Date:
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
Re: how can one infer the maximum possible restore time from a WAL file(name) in a backup?
From
Tom Lane
Date:
"Zwettler Markus (OIZ)" <Markus.Zwettler@zuerich.ch> writes: > In Oracle there is a view v$archived_log in which for each logfile the time of the first and last transaction containedin it is indicated. By means of this view one can infer from a log file in the backup the maximum possible recoverytime. > Is there something similar in Postgres? Or in other words, how can one infer the maximum possible restore time from a WALfile(name) in a backup? There's no view, but you could use pg_waldump to examine the timestamps of the first and last COMMIT/ROLLBACK records in a WAL file. regards, tom lane