Incremental / Level -1 backup in PG

From: Rakesh Kumar <rakeshkumar464(at)outlook(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Incremental / Level -1 backup in PG
Date: 2017-03-22 00:27:31
Message-ID: DM5PR2201MB15610955426547E18CFE63528C3C0@DM5PR2201MB1561.namprd22.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2017-03-22 00:35:32 Re: Incremental / Level -1 backup in PG
Previous Message Adrian Klaver 2017-03-21 23:57:35 Re: mysql_config_editor feature suggestion