Hi,
not sure if this is known behavior.
Server version is 14.6 (Debian 14.6-1.pgdg110+1).
In a PITR setup I have these settings:
recovery_target_xid = '852381'
recovery_target_inclusive = 'false'
recovery_target_inclusive = 'false'
In the log file I see this message:
LOG: recovery stopping before commit of transaction 852381, time 2000-01-01 00:00:00+00
But:
postgres=# select * from pg_last_committed_xact();
xid | timestamp | roident
--------+-------------------------------+---------
852380 | 2023-01-16 18:00:35.054495+00 | 0
xid | timestamp | roident
--------+-------------------------------+---------
852380 | 2023-01-16 18:00:35.054495+00 | 0
So, the timestamp displayed in the log message is certainly wrong.
Thanks,
Torsten
