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.mla...@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 > > > >
