On 1/9/23 11:23, Torsten Förtsch wrote:
On Mon, Jan 9, 2023 at 10:59 AM Adrien Nayrat
mailto:adrien.nay...@anayrat.info>> wrote:
* We can't perform PITR on a cluster without any activity since 13
* It seems creating restore point doesn't record a timestamp in wal.
I have a cron job th
On Mon, Jan 9, 2023 at 10:59 AM Adrien Nayrat
wrote:
>
> * We can't perform PITR on a cluster without any activity since 13
> * It seems creating restore point doesn't record a timestamp in wal.
>
I have a cron job that runs this every 5 minutes:
SELECT txid_current() WHERE
(pg_last_committed_x
Hello,
I bump this thread up, I hope to have more reaction :)
TL;DR:
* We can't perform PITR on a cluster without any activity since 13
* It seems creating restore point doesn't record a timestamp in wal.
Thanks
--
Adrien NAYRAT
Hello,
I came across a weird problem about PITR with a recovery_target_time and
a cluster without any activity. The issue is quite simple, we just try
to do a PITR by specifying a recovery_target_time after the backup.
The main issue, is that there is no timestamp in the wal as there is no
a
