| From: | Ron Johnson <ronljohnsonjr(at)gmail(dot)com> |
|---|---|
| To: | "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: PITR |
| Date: | 2023-11-22 10:50:59 |
| Message-ID: | CANzqJaDq4eUikUxAsj6WVyNrxwi94wJ2buW-_RcM=eoS6XmXsQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-general |
On Wed, Nov 22, 2023 at 3:12 AM Rajesh Kumar <rajeshkumar(dot)dba09(at)gmail(dot)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 ".
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andreas Kretschmer | 2023-11-22 10:54:21 | Re: PITR |
| Previous Message | Laurenz Albe | 2023-11-22 09:01:02 | Re: PITR |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andreas Kretschmer | 2023-11-22 10:54:21 | Re: PITR |
| Previous Message | Laurenz Albe | 2023-11-22 09:39:03 | Re: Connection fails on one system in a address range allowed to connect |