Re: Differential Backups in Windows server

> On 27/04/2023 13:24 CEST Rajmohan Masa <razmohan6(at)gmail(dot)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