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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Zwettler Markus (OIZ)" <Markus(dot)Zwettler(at)zuerich(dot)ch>
Cc: "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: how can one infer the maximum possible restore time from a WAL file(name) in a backup?
Date: 2022-11-21 14:31:57
Message-ID: 3116564.1669041117@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Zwettler Markus (OIZ)" <Markus(dot)Zwettler(at)zuerich(dot)ch> writes:
> 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?

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

In response to

Browse pgsql-admin by date

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