Re: Review my steps for rollback to restore point

Поиск
Список
Период
Сортировка
От chandan Kumar
Тема Re: Review my steps for rollback to restore point
Дата
Msg-id CAHV6zV=G3od8Pa7XOH5dR6LUZQ2aoM__zyV-GMWrfyz=gufF9A@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Review my steps for rollback to restore point  ("David G. Johnston" <david.g.johnston@gmail.com>)
Ответы Re: Review my steps for rollback to restore point
Список pgsql-general
Thank you for your time and clarification. 
Does PITR recreate database internally ?  can i say it is not the same as pg_restore  or it is same as pg_restore plus applying WAL on top of it.  I am asking because can we revern DDL operations without PITR in streaming replication

On Tue, Mar 4, 2025 at 8:37 PM David G. Johnston <david.g.johnston@gmail.com> wrote:
On Tuesday, March 4, 2025, chandan Kumar <chandan.issyoga@gmail.com> wrote:
Thank you for your answer.  I want to clarify one more doubt.  Can PITR be achieved without applying Base Backup

The point-in-time you choose must be in the future relative to whatever data files you are applying WAL on top of.  That is only possible of you’ve backed up the data files at some point in the past and use that backup.

David J.



--
With warm regards
     Chandan

В списке pgsql-general по дате отправления: