| From: | Holger Jakobs <holger(at)jakobs(dot)com> |
|---|---|
| To: | pgsql-admin(at)lists(dot)postgresql(dot)org |
| Cc: | rajeshkumar(dot)dba09(at)gmail(dot)com |
| Subject: | Re: PITR |
| Date: | 2023-11-22 08:23:16 |
| Message-ID: | 32d5ce00-9624-e072-2b1a-9f6637369c1e@jakobs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-general |
Am 22.11.23 um 09:11 schrieb Rajesh Kumar:
> Hi
>
> 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.
Monitoring DDL commands works fine using event triggers
https://www.postgresql.org/docs/current/event-triggers.html
Code of event triggers may even fail a command by raising an exception
preventing the command becoming effective.
Regards,
Holger
--
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Laurenz Albe | 2023-11-22 09:01:02 | Re: PITR |
| Previous Message | Rajesh Kumar | 2023-11-22 08:20:44 | Re: Pgbouncer |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Inzamam Shafiq | 2023-11-22 08:38:56 | Re: Connection fails on one system in a address range allowed to connect |
| Previous Message | Rajesh Kumar | 2023-11-22 08:11:46 | PITR |