On Wed, 2023-11-22 at 13:41 +0530, Rajesh Kumar wrote:
> 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.
You can monitor that by setting "log_statement = 'ddl'".
Yours,
Laurenz Albe