Re: PITR

[Ron Johnson <ronljohnsonjr@xxxxxxxxx>]

On Wed, Nov 22, 2023 at 3:12 AM Rajesh Kumar <rajeshkumar.dba09@xxxxxxxxx> 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 ".