Re: PITR - Mailing list pgsql-admin

From Laurenz Albe
Subject Re: PITR
Date
Msg-id 75f78597be2cb32dd8f7408208567e0a2d9b7ecd.camel@cybertec.at
Whole thread Raw
In response to PITR  (Rajesh Kumar <rajeshkumar.dba09@gmail.com>)
List 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



pgsql-admin by date:

Previous
From: Kashif Zeeshan
Date:
Subject: Re: PITR
Next
From: Ron Johnson
Date:
Subject: Re: PITR