Postgres incremental backups per db (not per cluster)

From: Jaime Solorzano <jaisol(at)hotmail(dot)com>
To: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Postgres incremental backups per db (not per cluster)
Date: 2021-09-23 22:10:00
Message-ID: BN3PR04MB2370675171A23B468B1D4BB7DDA39@BN3PR04MB2370.namprd04.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thank you !

________________________________
From: Ron <ronljohnsonjr(at)gmail(dot)com>
Sent: Thursday, September 23, 2021 02:37 PM
To: pgsql-general(at)lists(dot)postgresql(dot)org <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Postgres incremental backups per db (not per cluster)

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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jaime Solorzano 2021-09-23 22:10:21 Re: Postgres incremental backups per db (not per cluster)
Previous Message Adrian Klaver 2021-09-23 21:56:45 Re: Postgres incremental backups per db (not per cluster)