On 3/21/2017 5:27 PM, Rakesh Kumar wrote:
PG does not have a concept of incremental backup. The way it works in Oracle
and other RDBMS is that incremental backup only backups up changed blocks since
the last full backup. So if only 10% of blocks changed since the last full
backup, incremental backup will be only for 10%.
I am wondering whether it is technically feasible to implement it like this:
1 - At the time of full backup, note the last modified time of each data file
in a repository.
2 - Next time when incremental backup runs, for every data file it will check
the last modified time of it with the one in the repository to determine
whether it has changed since last full backup. If yes, back it up.
Now on to restore:
1 - First restore full backup.
2 - Restore incremental backup.
My question: Will it work in PG?
basebackup + WAL archive lets you do just exactly this. you can
restore to any transaction between when that basebackup was taken, and
the latest entry in the WAL archive, its referred in the documentation
as PITR, Point in Time Recovery.
--
john r pierce, recycling bits in santa cruz
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
