Re: [GENERAL] Incremental / Level -1 backup in PG

Поиск
Список
Период
Сортировка
От Oleg Bartunov
Тема Re: [GENERAL] Incremental / Level -1 backup in PG
Дата
Msg-id CAF4Au4wK3OYeBcRtE2DReU+-REm+u=j=--+aepT-V2eX3Y2=xw@mail.gmail.com
обсуждение исходный текст
Ответ на [GENERAL] Incremental / Level -1 backup in PG  (Rakesh Kumar <rakeshkumar464@outlook.com>)
Список pgsql-general


On Wed, Mar 22, 2017 at 3:27 AM, Rakesh Kumar <rakeshkumar464@outlook.com> 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:

Have you seen pg_probackup ? It's in development stage and needs somebody to test it.

 

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?


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

В списке pgsql-general по дате отправления:

Предыдущее
От: Stephen Frost
Дата:
Сообщение: Re: [GENERAL] Incremental / Level -1 backup in PG
Следующее
От: rakeshkumar464
Дата:
Сообщение: Re: [GENERAL] Incremental / Level -1 backup in PG