Re: Postgres incremental backups per db (not per cluster)

Ron <ronljohnsonjr@xxxxxxxxx> · Thu, 23 Sep 2021 15:37:51 -0500



    On 9/23/21 2:57 PM, Jaime Solorzano wrote:

    
          According
            to the WAL Point-in-time recovery and incremental backup
            documentation, pg_basebackup and wals are used to take
            backups and incremental backups of a running PostgreSQL
            cluster.
          

          I
            wonder if there is a way to take incremental backups per
            database instead of the entire cluster.
        
      
    You're not the first to ask (I wasn't the first either...), and not
    the first to hear said, "it's not possible".

    
    -- 

      Angular momentum makes the world go 'round.