Re: What's the dfifference between pg_start_backup+copy+pg_stop_backup+WAL vs. pg_start_backup+pg_stop_backup+copy+WAL?

Поиск
Список
Период
Сортировка
От Scott Ribe
Тема Re: What's the dfifference between pg_start_backup+copy+pg_stop_backup+WAL vs. pg_start_backup+pg_stop_backup+copy+WAL?
Дата
Msg-id 6780C96C-3016-47C8-AD06-BF860283266C@elevated-dev.com
обсуждение исходный текст
Ответ на Re: What's the dfifference between pg_start_backup+copy+pg_stop_backup+WAL vs. pg_start_backup+pg_stop_backup+copy+WAL?  (Thorsten Schöning<tschoening@am-soft.de>)
Ответы Re: What's the dfifference between pg_start_backup+copy+pg_stop_backup+WAL vs. pg_start_backup+pg_stop_backup+copy+WAL?  (Thorsten Schöning<tschoening@am-soft.de>)
Список pgsql-admin
Дерево обсуждения 
> On Jul 23, 2021, at 11:44 AM, Thorsten Schöning <tschoening@am-soft.de> wrote:
>
> So why is that row used at all instead of simply ignored?

Because it is in the file. WAL can re-do changes, it cannot undo them.

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

Предыдущее
От: Alvaro Aguayo
Дата:
Сообщение: RE: database lagging
Следующее
От: Stephen Frost
Дата:
Сообщение: Re: What's the dfifference between pg_start_backup+copy+pg_stop_backup+WAL vs. pg_start_backup+pg_stop_backup+copy+WAL?