[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]


Thank you all

On Fri, 17 May 2024, 19:12 MichaelDBA, <MichaelDBA@xxxxxxxxxxx> wrote:
To answer your question, logging DDL does not have ANYTHING to do with PITR.  So the answer is "NO, you cannot do PITR by just logging logging DDL".

You have to use binary backups and continuous WAL logging to be able to do PITR.  There are many tools out there to do that.  The best one in my opinion is PGBackrest.

Michael Vitale

Ron Johnson wrote on 5/17/2024 9:26 AM:
On Fri, May 17, 2024 at 7:35 AM Rajesh Kumar <rajeshkumar.dba09@xxxxxxxxx> 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.


Michael Vitale




JPEG image

JPEG image

[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux