Postgres Pro
Downloads
Home   >   mailing lists

Re: how can one infer the maximum possible restore time from a WAL file(name) in a backup? - Mailing list pgsql-admin

From Tom Lane
Subject Re: how can one infer the maximum possible restore time from a WAL file(name) in a backup?
Date
Msg-id 3116564.1669041117@sss.pgh.pa.us
Whole thread Raw
In response to how can one infer the maximum possible restore time from a WAL file(name) in a backup?  ("Zwettler Markus (OIZ)" <Markus.Zwettler@zuerich.ch>)
List pgsql-admin
Tree view 
"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

pgsql-admin by date:

Previous
From: Ron
Date:
Subject: Re: user credentials rejected by pgAdmin right after new install
Next
From: Tom Lane
Date:
Subject: Re: Finding query execution time using \timing and EXPLAIN ANALYZE..