Postgres Pro
Downloads
Home   >   mailing lists

Thread: Re: PITR

Re: PITR

From
Ron Johnson
Date:
On Wed, Nov 22, 2023 at 3:12 AM Rajesh Kumar <rajeshkumar.dba09@gmail.com> wrote:
Hi

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

Revoke his permission to drop tables?


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. 
 
Set log_statement to 'all' or 'ddl', and then grep the log files for "DROP TABLE ".

Re: PITR

From
Andreas Kretschmer
Date:

Am 22.11.23 um 11:50 schrieb Ron Johnson:
> On Wed, Nov 22, 2023 at 3:12 AM Rajesh Kumar 
> <rajeshkumar.dba09@gmail.com> wrote:
>
>
>
>     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.
>

https://blog.hagander.net/locating-the-recovery-point-just-before-a-dropped-table-230/


Andreas

-- 
Andreas Kretschmer - currently still (garden leave)
Technical Account Manager (TAM)
www.enterprisedb.com