Re: Review my steps for rollback to restore point
| От | chandan Kumar |
|---|---|
| Тема | Re: Review my steps for rollback to restore point |
| Дата | |
| Msg-id | CAHV6zVm73D1pMUqg50Nep3pSh+eP-aAsRyUwu8qXFzudKjZb+g@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 |
Hi David,
You catched my word "revert". Thats so encouraging to see how this community helps. Your answer has cleared my 99% doubt. Thanks again.
I wish I also contribute one day . Have a good time!
You catched my word "revert". Thats so encouraging to see how this community helps. Your answer has cleared my 99% doubt. Thanks again.
I wish I also contribute one day . Have a good time!
On Tue, Mar 4, 2025 at 9:08 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 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 replicationPostgreSQL doesn’t have a concept of “revert”.PITR just deals with raw bytes on disk for an entire cluster. If a new file appears in the WAL that file is created. That file can be a directory for a database.You cannot mix physical and logical images of the database so applying WAL on top of pg_restore is technically invalid - but it does effective convey the idea. It’s like saying pg_dump and pg_basebackup are similar. Sure, in some ways that is true - but the logical vs. physical distinction cannot be ignored fully.David J.
With warm regards
Chandan
В списке pgsql-general по дате отправления: