Postgres Pro
Downloads
Home   >   mailing lists

Any way to get timestamp from LSN value ? - Mailing list pgsql-hackers

From Harinath Kanchu
Subject Any way to get timestamp from LSN value ?
Date
Msg-id 308CC288-DE04-4091-A7DE-036370B7293B@apple.com
Whole thread Raw
Responses Re: Any way to get timestamp from LSN value ?
List pgsql-hackers
Tree view
Hello,

Is there any way to get the timestamp of the transaction using LSN value ?

For example: 
can we use the minimum recovery ending location in pg control file to get the minimum recovery timestamp ?

Minimum recovery ending location:     28/28000B68


Thanks in advance,

Best,
Harinath.

pgsql-hackers by date:

Previous
From: Amit Langote
Date:
Subject: Re: Skip partition tuple routing with constant partition key
Next
From: "alvherre@alvh.no-ip.org"
Date:
Subject: Re: [BUG] Panic due to incorrect missingContrecPtr after promotion