Re: Using pg_rewind for differential backup

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: Using pg_rewind for differential backup
Дата
Msg-id CAB7nPqQEJmXMkq8ENaY+k8dL9nmC8GQEXHaYL5zU+Oi814TV1A@mail.gmail.com
обсуждение исходный текст
Ответ на Using pg_rewind for differential backup  (Sameer Kumar <sameer.kumar@ashnik.com>)
Ответы Re: Using pg_rewind for differential backup  (Heikki Linnakangas <hlinnakangas@vmware.com>)
Список pgsql-hackers
Дерево обсуждения


On Thu, Nov 27, 2014 at 9:39 PM, Sameer Kumar <sameer.kumar@ashnik.com> wrote:
Can we tweak pg_rewind to take differential backups in PostgreSQL?
I was wondering can we hack the pg_rewind code to print the details of the file which have been modified compared to a target server. The list output can then be used for taking differential backups.

Or perhaps we can add an option/switch in pg_rewind --action

--action=print ---> would print the files which have changed
--action=sync ---> would sync them
--action=copy ---> with this option I can specify an additional optino --target-dir where I can copy the files which have changed

This discussion is not really adapted on hackers as pg_rewind is not included in Postgres core code. Please let's discuss your proposal there. Btw, pg_rewind is not aimed to be used as a tool for a backup facility. You may find easier to use existing backup solutions instead, or help out with an in-core solution. There was actually not so long ago a patch to implement in-core differential backups, with a part called profiles able to fetch back the list of files modified since a given LSN point (only an improvement of the core feature though as that's not mandatory to make the machinery work). The patch has not been added to any of the recent commit fests though.
Regards,
--
Michael

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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: [REVIEW] Re: Compression of full-page-writes
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: Re: Allocation in critical section after node exits archive recovery