Обсуждение:
Hi everyone.
how to take incremental backup in postgresql windows machine.
Thank you And Regards
Obireddy.G
> > > 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.
Hi,
On Friday, August 27, 2021, obi reddy <obireddy.g1997@gmail.com> wrote:
You can try to make a batch script in windows for taking incremental backup and schedule it in windows scheduler.
Regards
Regards
Atul
On Friday, August 27, 2021, obi reddy <obireddy.g1997@gmail.com> wrote:
Hi everyone.how to take incremental backup in postgresql windows machine.Thank you And RegardsObireddy.G
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
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