On 1/9/23 11:23, Torsten Förtsch wrote:
> On Mon, Jan 9, 2023 at 10:59 AM Adrien Nayrat
> <adrien.nayrat@anayrat.info <mailto:adrien.nayrat@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 that runs this every 5 minutes:
>
> SELECT txid_current() WHERE
> (pg_last_committed_xact()).timestamp+'5min'::INTERVAL < now()
>
> Combine that with a suitable value for archive_timeout.
Hello,
I don't get how it could be useful ?
When we perform PITR, we don't know if there was activity or not.
--
Adrien NAYRAT