pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
how can one infer the maximum possible restore time from a WAL file(name) in a backup? 2+ messages / 2 participants [nested] [flat]
* how can one infer the maximum possible restore time from a WAL file(name) in a backup? @ 2022-11-21 12:45 Zwettler Markus (OIZ) <Markus.Zwettler@zuerich.ch> 0 siblings, 1 reply; 2+ messages in thread From: Zwettler Markus (OIZ) @ 2022-11-21 12:45 UTC (permalink / raw) To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org> 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: how can one infer the maximum possible restore time from a WAL file(name) in a backup? @ 2022-11-21 14:31 Tom Lane <tgl@sss.pgh.pa.us> parent: Zwettler Markus (OIZ) <Markus.Zwettler@zuerich.ch> 0 siblings, 0 replies; 2+ messages in thread From: Tom Lane @ 2022-11-21 14:31 UTC (permalink / raw) To: Zwettler Markus (OIZ) <Markus.Zwettler@zuerich.ch>; +Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org> "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 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2022-11-21 14:31 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2022-11-21 12:45 how can one infer the maximum possible restore time from a WAL file(name) in a backup? Zwettler Markus (OIZ) <Markus.Zwettler@zuerich.ch> 2022-11-21 14:31 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox