Postgres Pro
Downloads
Home   >   mailing lists

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

From Zwettler Markus (OIZ)
Subject how can one infer the maximum possible restore time from a WAL file(name) in a backup?
Date
Msg-id 173875f2fb734d46877eecf55ae0682e@zuerich.ch
Whole thread Raw
Responses Re: how can one infer the maximum possible restore time from a WAL file(name) in a backup?
List pgsql-admin
Tree view

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

 

 

pgsql-admin by date:

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