Postgres Pro
Downloads
Home   >   mailing lists

Re: PITR and instance without any activity - Mailing list pgsql-general

From Torsten Förtsch
Subject Re: PITR and instance without any activity
Date
Msg-id CAKkG4_ktVLr1SqPJonACTDT12R36+hM1dix_fyE0fK2jk30RMw@mail.gmail.com
Whole thread Raw
In response to Re: PITR and instance without any activity  (Adrien Nayrat <adrien.nayrat@anayrat.info>)
Responses Re: PITR and instance without any activity
List pgsql-general
Tree view
On Mon, Jan 9, 2023 at 10:59 AM Adrien Nayrat <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.

pgsql-general by date:

Previous
From: hubert depesz lubaczewski
Date:
Subject: Re: Exact same output - pg_stat_statements
Next
From: Matthias Apitz
Date:
Subject: How do the Linux distributions create the Linux user/group "postgres"?