Search Postgresql Archives

Re: Differential Backups in Windows server

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



> On 27/04/2023 13:24 CEST Rajmohan Masa <razmohan6@xxxxxxxxx> 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





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux