Re: PITR - Mailing list pgsql-admin

From Ron Johnson
Subject Re: PITR
Date
Msg-id CANzqJaA65rqOEBRt+jUdF2nGmMOyU0nhA9TjpiPi9NqxcX1tFw@mail.gmail.com
Whole thread Raw
In response to PITR  (Rajesh Kumar <rajeshkumar.dba09@gmail.com>)
Responses Re: PITR
List pgsql-admin
On Fri, May 17, 2024 at 7:35 AM Rajesh Kumar <rajeshkumar.dba09@gmail.com> wrote:
Hi all,


I want to verify one thing. If I am logging only ddl and if somebody update data incorrectly and if we don't know the time, can we do pitr or not?

 If your system is busy, then log_statement = 'mod' is going to generate a LOT of pg_log data.

pgsql-admin by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: PITR
Next
From: MichaelDBA
Date:
Subject: Re: PITR