Postgres Pro
Downloads
Home   >   mailing lists

Re: Print pg_lsn as a number? - Mailing list pgsql-general

From Andres Freund
Subject Re: Print pg_lsn as a number?
Date
Msg-id 20180612173943.rkzhfcjzaipjvs4n@alap3.anarazel.de
Whole thread Raw
In response to Print pg_lsn as a number?  (Scott Stroupe <sstroupe@kofile.net>)
Responses Re: Print pg_lsn as a number?  (Scott Stroupe <sstroupe@kofile.net>)
Re: Print pg_lsn as a number?  (Michael Paquier <michael@paquier.xyz>)
List pgsql-general
Tree view 
Hi,

On 2018-06-12 09:31:49 -0700, Scott Stroupe wrote:
> According to the documentation[1], pg_lsn is a 64-bit integer that's
> printed as two hex numbers separated by a slash, e.g. 68/1225BB70. Is
> there a way to get the 64-bit integer in a common numeric
> representation instead of the peculiar hex-slash-hex representation?

What do you want to do with the LSN?

Greetings,

Andres Freund

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Software that can automatically make sense of a DB's tables andID names
Next
From: "btober@computer.org"
Date:
Subject: What does Natvie Posgres mean?