| From: | Scott Stroupe <sstroupe(at)kofile(dot)net> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Print pg_lsn as a number? |
| Date: | 2018-06-12 20:07:09 |
| Message-ID: | 0D7680DE-6EF6-4770-8012-6AC71F1FDD88@kofile.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> On Jun 12, 2018, at 10:39 AM, Andres Freund <andres(at)anarazel(dot)de> wrote:
>
> 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
I want to put pg_lsns into a tool that only understands common numeric representations, to do simple math and comparisons.
Regards,
Scott
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Murthy Nunna | 2018-06-12 20:34:56 | pg_upgrade 10.2 |
| Previous Message | Ron | 2018-06-12 18:37:30 | Re: What does Natvie Posgres mean? |