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?
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.