patternsqlMinor
Is it Possible To Take Full And Differential Backup in Postgresql Like Sql Server?
Viewed 0 times
postgresqlfullserversqltakelikepossibledifferentialandbackup
Problem
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?
Solution
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
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
Context
StackExchange Database Administrators Q#257833, answer score: 4
Revisions (0)
No revisions yet.