Обсуждение: Differential Backups in Windows server
Hi Team,
Is it possible to take differential Backup in Windows Server ? If possible please explain clearly?
I tried with different scenarios but I'm unable to take Diff Backup of the postgresql database in Windows server.
Much appreciated for Response.
Thank you,
Rajamohan M.
> On 27/04/2023 13:24 CEST Rajmohan Masa <razmohan6@gmail.com> wrote: > > Is it possible to take differential Backup inWindows Server ?If possible > please explain clearly? Not to my knowledge. Postgres itself only allows full backups via pg_basebackup or pg_dumpall. Barman[0] allows differential backup via rsync+ssh which is, however, not supported on Windows. Barman supports Windows with pg_basebackup. pgBackRest[1] and pg_rman[2] also provide differential backup but neither one supports Windows. I found SQLBackupAndFTP when searching for a Windows solution. It advertises with support for differential backups, but that's possible with SQL Server only. [3] I went with Barman to have PITR on that one Windows server I have to manage and accept that it only allows full backups. My Linux Postgres clusters are covered by rsync+ssh though. > I tried with different scenarios but I'm unable to take Diff Backup of the > postgresql database in Windows server. What have you tried? [0] https://pgbarman.org [1] https://pgbackrest.org/ [2] https://github.com/ossc-db/pg_rman [3] https://sqlbackupandftp.com/features -- Erik