0

I have a postgresql server. I want to take its backup full and differential mode as it is like in sql server. Is it possible to do this in postgresql? How can i do it, if it is?

0

There is nothing built-in for Postgres.

But two very popular backup tools support differential backups:

  • there is wal_archiving, which can work the same way MSSQL differential backup works other than MS diff backups include everything from the last full backup – zsheep Jan 22 at 18:02
0

There is method called continuous Wal_Archiving, that can simulate The Diff backups in MSSQL

You run pg_basebackup instead of pg_dump, then ship the WAL_Logs to the backups server.

To recover from a failure, restore the last good backup and replay the WALs from the point in time from the last backup.

Depending on configuration can be better than DIFF backups as this gets the sever up to the last WAL file.

Here is a nice write up

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.