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@xxxxxxxxx> 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
