PITR

From: Rajesh Kumar <rajeshkumar(dot)dba09(at)gmail(dot)com>
To: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: PITR
Date: 2023-11-22 08:11:46
Message-ID: CAJk5Atb_8Rmr8DmxWFmtR44CRQrT9cc4Nso9Z85owT3E-=OQ0w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

Hi

A person dropped the table and don't know time of drop.

How do I do PITR. Backup strategy is weekly full backup and daily
differential backup. Using pgbackrest.

Also. In future how do i monitor time of drop commands.

Responses

  • Re: PITR at 2023-11-22 08:23:16 from Holger Jakobs
  • Re: PITR at 2023-11-22 09:01:02 from Laurenz Albe
  • Re: PITR at 2023-11-22 10:50:59 from Ron Johnson

Browse pgsql-admin by date

  From Date Subject
Next Message Rajesh Kumar 2023-11-22 08:20:44 Re: Pgbouncer
Previous Message 舒兰） <sweety.soul7@gmail.com> 2023-11-21 01:57:57 Re: GSSAPI authentication on Redhat8 and PostgreSQL15/16

Browse pgsql-general by date

  From Date Subject
Next Message Holger Jakobs 2023-11-22 08:23:16 Re: PITR
Previous Message Achilleas Mantzios 2023-11-22 06:19:54 Re: Removing oids with pg_repack