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

List:       postgresql-general
Subject:    Re:
From:       obi reddy <obireddy.g1997 () gmail ! com>
Date:       2021-08-28 1:29:22
Message-ID: CAO7L2ZyaOTUmWf3+MpzL5n=YP4sXCJDY3ePqxOjJVWw68=UN0A () mail ! gmail ! com
[Download RAW message or body]

Dear Gogala

Pg_RMAN is not support on windows machine.  I have small about the can I
set the archive_commnad and I will take the wal files  like incremental
backup.

On Sat, 28 Aug 2021, 1:15 am Mladen Gogala, <gogala.mladen@gmail.com> wrote:

> On 8/27/21 8:59 AM, Ravi Krishna wrote:
> >>
> >> how to take incremental backup in postgresql windows machine.
> >>
> > AFAIK PG has no concept of incremental backup.  pgbackrest has, but not
> sure whether it runs on Windows.
>
> PG_RMAN can do incremental backups. I think it does the same thing as
> Oracle  without enabled block change tracking: it backs up all the files
> changed since the last full backup. However, that doesn't help you much
> because of the vacuum which can touch the file well after it has been
> referenced in transaction. I like pg_rman because it can automatically
> delete old backups and keep only 4 latest backups.
>
> --
>
> Mladen Gogala
> Database Consultant
> Tel: (347) 321-1217
> https://dbwhisperer.wordpress.com
>
>
>
>

[Attachment #3 (text/html)]

<div dir="auto"><div>Dear Gogala  </div><div dir="auto"><br></div><div \
dir="auto">Pg_RMAN is not support on windows machine.   I have small about the can I \
set the archive_commnad and I will take the wal files   like incremental backup.    \
<br><br><div class="gmail_quote" dir="auto"><div dir="ltr" class="gmail_attr">On Sat, \
28 Aug 2021, 1:15 am Mladen Gogala, &lt;<a href="mailto:gogala.mladen@gmail.com" \
target="_blank" rel="noreferrer">gogala.mladen@gmail.com</a>&gt; \
wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 \
.8ex;border-left:1px #ccc solid;padding-left:1ex">On 8/27/21 8:59 AM, Ravi Krishna \
wrote:<br> &gt;&gt;<br>
&gt;&gt; how to take incremental backup in postgresql windows machine.<br>
&gt;&gt;<br>
&gt; AFAIK PG has no concept of incremental backup.   pgbackrest has, but not sure \
whether it runs on Windows.<br> <br>
PG_RMAN can do incremental backups. I think it does the same thing as <br>
Oracle   without enabled block change tracking: it backs up all the files <br>
changed since the last full backup. However, that doesn&#39;t help you much <br>
because of the vacuum which can touch the file well after it has been <br>
referenced in transaction. I like pg_rman because it can automatically <br>
delete old backups and keep only 4 latest backups.<br>
<br>
-- <br>
<br>
Mladen Gogala<br>
Database Consultant<br>
Tel: (347) 321-1217<br>
<a href="https://dbwhisperer.wordpress.com" rel="noreferrer noreferrer noreferrer" \
target="_blank">https://dbwhisperer.wordpress.com</a><br> <br>
<br>
<br>
</blockquote></div></div></div>



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