Re: PITR and instance without any activity

From: Torsten Förtsch <tfoertsch123(at)gmail(dot)com>
To: Adrien Nayrat <adrien(dot)nayrat(at)anayrat(dot)info>
Cc: PostgreSQL General <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: PITR and instance without any activity
Date: 2023-01-09 10:23:17
Message-ID: CAKkG4_ktVLr1SqPJonACTDT12R36+hM1dix_fyE0fK2jk30RMw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Jan 9, 2023 at 10:59 AM Adrien Nayrat <adrien(dot)nayrat(at)anayrat(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Matthias Apitz 2023-01-09 12:41:57 How do the Linux distributions create the Linux user/group "postgres"?
Previous Message hubert depesz lubaczewski 2023-01-09 10:15:06 Re: Exact same output - pg_stat_statements