Re: Incremental backup

[Ron <ronljohnsonjr@xxxxxxxxx>]

    On 10/28/21 1:00 PM, Adrian Klaver wrote:
> On
>       10/28/21 10:51, Ron wrote:
>       
>       
> > >           
> > >           Except we have no way of knowing what the situation is. I
> > >           prefer not to assume a context.
> > >           
> > >         
> >         
> >         You make it sound like incremental (and differential) backups
> >         are some complicated thing that needs context.  That's utter and
> >         complete rubbish in every Enterprise RDBMS except Postgresql.
> >         
> >         
> >       
>       
>       This is Postgres so we do need context.
>       
>       
>       Also you have not defined what you consider incremental backup? I
>       for one would put this:
>       
>       
>       https://www.postgresql.org/docs/14/continuous-archiving.html
>       
>     
    
    I define Incremental and Differential backups the way everyone else
    does:
    
    Incremental Backup: capture all changed data since the last
    incremental backup.  (Not the same as WAL archiving.)
    Differential Backup: capture all changed data since the last
    full backup.
    Transaction Backup: capture all transactions in a log file.
    
>       
>       forward as a candidate.
>       
>       
> > Something like "BACKUP DATABASE
> >         (DIFFERENTIAL) foo TO foo.bak;" should be a fundamental feature
> >         of every RDBMS that claims to be enterprise class.
> >         
> >       
>       
>       Knock your self out:
>       
>       
>       https://wiki.postgresql.org/wiki/Developer_FAQ
>       
>     
    
    Not doable in Postgresql because WAL files are global to cluster. 
    I've read multiple times that will not be changed.
    
    PgBackRest does full and incremental backups, plus captures WAL
    files, but globally to a cluster.

--
Angular momentum makes the world go 'round.