Re: PITR

From: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
To: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: PITR
Date: 2024-05-17 13:26:16
Message-ID: CANzqJaA65rqOEBRt+jUdF2nGmMOyU0nhA9TjpiPi9NqxcX1tFw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Fri, May 17, 2024 at 7:35 AM Rajesh Kumar <rajeshkumar(dot)dba09(at)gmail(dot)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.

In response to

  • PITR at 2024-05-17 11:35:01 from Rajesh Kumar

Responses

  • Re: PITR at 2024-05-17 13:41:45 from MichaelDBA

Browse pgsql-admin by date

  From Date Subject
Next Message MichaelDBA 2024-05-17 13:41:45 Re: PITR
Previous Message Laurenz Albe 2024-05-17 11:53:32 Re: PITR