Postgres Pro
Downloads
Home   >   mailing lists

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

Postgres incremental backups per db (not per cluster)

From
Jaime Solorzano
Date:

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.


Thanks !


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

From
Ron
Date:
On 9/23/21 2:57 PM, Jaime Solorzano wrote:
P {margin-top:0;margin-bottom:0;}

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.

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

From
Adrian Klaver
Date:
On 9/23/21 12: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 already know the answer to that:

https://stackoverflow.com/questions/69304047/postgres-incremental-backups-per-db-not-per-cluster

> 
> 
> Thanks !
> 
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com

Postgres incremental backups per db (not per cluster)

From
Jaime Solorzano
Date:
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.

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

From
Jaime Solorzano
Date:
Thanks !

From: Adrian Klaver <adrian.klaver@aklaver.com>
Sent: Thursday, September 23, 2021 03:56 PM
To: Jaime Solorzano <jaisol@hotmail.com>; pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>
Subject: Re: Postgres incremental backups per db (not per cluster)
 
On 9/23/21 12: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 already know the answer to that:

https://stackoverflow.com/questions/69304047/postgres-incremental-backups-per-db-not-per-cluster

>
>
> Thanks !
>
>


--
Adrian Klaver
adrian.klaver@aklaver.com