| From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
|---|---|
| To: | Rajesh Kumar <rajeshkumar(dot)dba09(at)gmail(dot)com>, Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: PITR |
| Date: | 2023-11-22 09:01:02 |
| Message-ID: | b754be5879d583c48413ec032f41f108249c026c.camel@cybertec.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ron Johnson | 2023-11-22 10:50:59 | Re: PITR |
| Previous Message | Holger Jakobs | 2023-11-22 08:23:16 | Re: PITR |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Laurenz Albe | 2023-11-22 09:39:03 | Re: Connection fails on one system in a address range allowed to connect |
| Previous Message | Vijaykumar Patil | 2023-11-22 08:57:50 | General support on postgres replication |