Postgres Pro
Downloads
Home   >   mailing lists

Postgres incremental backups per db (not per cluster) - Mailing list pgsql-general

From Jaime Solorzano
Subject Postgres incremental backups per db (not per cluster)
Date
Msg-id BN3PR04MB2370675171A23B468B1D4BB7DDA39@BN3PR04MB2370.namprd04.prod.outlook.com
Whole thread Raw
In response to Re: Postgres incremental backups per db (not per cluster)  (Ron <ronljohnsonjr@gmail.com>)
List pgsql-general
Tree view
Thank you !

From: Ron <ronljohnsonjr@gmail.com>
Sent: Thursday, September 23, 2021 02:37 PM
To: pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.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.

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Postgres incremental backups per db (not per cluster)
Next
From: Jaime Solorzano
Date:
Subject: Re: Postgres incremental backups per db (not per cluster)