Postgres Pro
Downloads
Home   >   mailing lists

Re: PITR - Mailing list pgsql-general

From Ron Johnson
Subject Re: PITR
Date
Msg-id CANzqJaDq4eUikUxAsj6WVyNrxwi94wJ2buW-_RcM=eoS6XmXsQ@mail.gmail.com
Whole thread Raw
Responses Re: PITR  (Andreas Kretschmer <andreas@a-kretschmer.de>)
List pgsql-general
Tree view
On Wed, Nov 22, 2023 at 3:12 AM Rajesh Kumar <rajeshkumar.dba09@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 ".

pgsql-general by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: Connection fails on one system in a address range allowed to connect
Next
From: Andreas Kretschmer
Date:
Subject: Re: PITR