Re:

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(dot)mladen(at)gmail(dot)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
>
>
>
>