Postgres Pro
Downloads
Home   >   mailing lists

Re: What's the dfifference between pg_start_backup+copy+pg_stop_backup+WAL vs. pg_start_backup+pg_stop_backup+copy+WAL? - Mailing list pgsql-admin

From Scott Ribe
Subject Re: What's the dfifference between pg_start_backup+copy+pg_stop_backup+WAL vs. pg_start_backup+pg_stop_backup+copy+WAL?
Date
Msg-id 6780C96C-3016-47C8-AD06-BF860283266C@elevated-dev.com
Whole thread Raw
In response to 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>)
Responses Re: What's the dfifference between pg_start_backup+copy+pg_stop_backup+WAL vs. pg_start_backup+pg_stop_backup+copy+WAL?
List pgsql-admin
Tree view 
> 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 by date:

Previous
From: Alvaro Aguayo
Date:
Subject: RE: database lagging
Next
From: Stephen Frost
Date:
Subject: Re: What's the dfifference between pg_start_backup+copy+pg_stop_backup+WAL vs. pg_start_backup+pg_stop_backup+copy+WAL?