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