How to know the exact time to which the database was recovered

From: Nikhil G Daddikar <ngd(at)celoxis(dot)com>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: How to know the exact time to which the database was recovered
Date: 2013-05-27 13:09:47
Message-ID: 51A35B1B.8090406@celoxis.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

We use the basebackup + WAL files strategy to backup our database i.e.
take a basebackup every day and copy WAL files to a remote server every
15 minutes. In case of a disaster on the master, we'd recover the
database on the slave. If this happens, I would like to tell the
customer the exact time till when the database was recovered. How do I
get this timestamp?

Thanks.
Nikhil

Browse pgsql-general by date

  From Date Subject
Next Message igivanoff 2013-05-27 13:37:07 Understanding postgresql logs
Previous Message Amit Langote 2013-05-27 08:15:26 Re: Seq Scan cost shown to be (cost=10000000000.00..10000000001.10)