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.*
<html><body><div dir="auto">PG does not have a concept of differential backup since it does not track block level changes. Pgbackrest has implemented a different backup using timestamp of last update in data files. Not sure whether it works in windows.</div><div id="ms-outlook-mobile-signature" dir="auto"><div><br></div><div dir="auto">--</div><div dir="auto">Sent from phone.</div></div><div id="mail-editor-reference-message-container" dir="auto"><br><hr style="display:inline-block;width:98%" tabindex="-1"><div id="divRplyFwdMsg" style="font-size: 11pt;"><strong>From:</strong> Rajmohan Masa <razmohan6@gmail.com><br><strong>Sent:</strong> Thursday, April 27, 2023, 7:25 AM<br><strong>To:</strong> pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org><br><strong>Subject:</strong> Differential Backups in Windows server<br></div><br><div dir="ltr">Hi Team,<div>Is it possible to take differential Backup in<b> Windows Server ? </b>If possible please explain clearly?</div><div>I tried with different scenarios but I'm unable to take <b>Diff Backup</b> of the postgresql database in <b>Windows server.</b></div><div><b><br></b></div><div><b>Much appreciated for Response.</b></div><div><b><br></b></div><div><b><br></b></div><div><b>Thank you,</b></div><div><b>Rajamohan M.</b></div></div>
<br></div></body></html>
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]https://pgbarman.org allows differential backup via rsync+ssh which is, however,
not supported on Windows. Barman supports Windows with pg_basebackup.
pgBackRest[1]https://pgbackrest.org/ and pg_rman[2]https://github.com/ossc-db/pg_rman 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]https://sqlbackupandftp.com/features
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