Re: PITR

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: 2024-05-17 11:53:32
Message-ID: 75f78597be2cb32dd8f7408208567e0a2d9b7ecd.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Fri, 2024-05-17 at 17:05 +0530, Rajesh Kumar wrote:
> 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?

- you cannot WAL log only DDL, you log everything

- if you don't know which time to recover to, you cannot recover to that time

Yours,
Laurenz Albe

In response to

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

Browse pgsql-admin by date

  From Date Subject
Next Message Ron Johnson 2024-05-17 13:26:16 Re: PITR
Previous Message Kashif Zeeshan 2024-05-17 11:46:13 Re: PITR