[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: Postgres incremental backups per db (not per cluster)
From:       Jaime Solorzano <jaisol () hotmail ! com>
Date:       2021-09-23 22:10:21
Message-ID: BN3PR04MB2370843B65C3D8FF9CE21A69DDA39 () BN3PR04MB2370 ! namprd04 ! prod ! outlook ! com
[Download RAW message or body]

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.or=
g <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-p=
er-db-not-per-cluster

>
>
> Thanks !
>
>


--
Adrian Klaver
adrian.klaver@aklaver.com

[Attachment #3 (text/html)]

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} \
</style> </head>
<body dir="ltr">
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: \
rgb(0, 0, 0);"> Thanks&nbsp;!</div>
<div>
<div id="appendonsend"></div>
<div style="font-family:Calibri,Helvetica,sans-serif; font-size:12pt; \
color:rgb(0,0,0)"> <br>
</div>
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" color="#000000" \
style="font-size:11pt"><b>From:</b> Adrian Klaver \
&lt;adrian.klaver@aklaver.com&gt;<br> <b>Sent:</b> Thursday, September 23, 2021 03:56 \
PM<br> <b>To:</b> Jaime Solorzano &lt;jaisol@hotmail.com&gt;; \
pgsql-general@lists.postgresql.org &lt;pgsql-general@lists.postgresql.org&gt;<br> \
<b>Subject:</b> Re: Postgres incremental backups per db (not per cluster)</font> \
<div>&nbsp;</div> </div>
<div class="BodyFragment"><font size="2"><span style="font-size:11pt">
<div class="PlainText">On 9/23/21 12:57 PM, Jaime Solorzano wrote:<br>
&gt; According to the WAL Point-in-time recovery and incremental backup <br>
&gt; documentation, pg_basebackup and wals are used to take backups and <br>
&gt; incremental backups of a running PostgreSQL cluster.<br>
&gt; <br>
&gt; <br>
&gt; I wonder if there is a way to take incremental backups per database <br>
&gt; instead of the entire cluster.<br>
<br>
You already know the answer to that:<br>
<br>
<a href="https://stackoverflow.com/questions/69304047/postgres-incremental-backups-per \
-db-not-per-cluster">https://stackoverflow.com/questions/69304047/postgres-incremental-backups-per-db-not-per-cluster</a><br>
 <br>
&gt; <br>
&gt; <br>
&gt; Thanks !<br>
&gt; <br>
&gt; <br>
<br>
<br>
-- <br>
Adrian Klaver<br>
adrian.klaver@aklaver.com<br>
</div>
</span></font></div>
</div>
</body>
</html>



[prev in list] [next in list] [prev in thread] [next in thread] 

Configure | About | News | Add a list | Sponsored by KoreLogic