Re: pg_controldata/pg_resetxlog "Latest checkpoint's NextXID" format

On 29/12/15 07:14, Joe Conway wrote:
> I wonder why "Latest checkpoint's NextXID" is formated like this:
>
> 8<-------------------------
>     printf(_("Latest checkpoint's NextXID:          %u/%u\n"),
>            ControlFile.checkPointCopy.nextXidEpoch,
>            ControlFile.checkPointCopy.nextXid);
> 8<-------------------------
>
> Shouldn't it use "%X/%X", same as e.g. "Prior checkpoint location" and
> all the other XIDs?

No. The "locations" in the output are WAL locations. Those are 
customarily printed with %X/%X. But NextXID is a transaction ID, those 
are printed in decimal, with %u.

- Heikki