> 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