Re: Differential Backups

Поиск
Список
Период
Сортировка
От Jeff Lu
Тема Re: Differential Backups
Дата
Msg-id LIEBJAJMJFLPHGCPMEBGOEELCEAA.jklcom@mindspring.com
обсуждение исходный текст
Ответ на Re: Differential Backups  (hubert depesz lubaczewski <depesz@depesz.pl>)
Ответы Re: Differential Backups  (hubert depesz lubaczewski <depesz@depesz.pl>)
Список pgsql-general
Can you show me an example on doing a backup using xdelta?

Thanks
-Jeff

-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org]On Behalf Of hubert depesz
lubaczewski
Sent: Tuesday, October 30, 2001 7:29 AM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Differential Backups


On Mon, 29 Oct 2001 12:22:44 -0800
"Ian Harding" <ianh@tpchd.org> wrote:

> I have been thinking about backups.  I currently do one a day.  However, I
thought it might be nice to get differential backups through the day.  I
should be able to generate dumps throughout the day, generate a diff from my
baseline dump, and just keep the diff, right?  Then to do a restore I would
just patch for the point in time I wanted to restore to?  Seems like it
would
work, but whether it would save any hard drive space would depend on how
much
activity the database saw.  Anyone doing this now?

idea is god, but dont use suggested diff program. go for xdelta. it's
algorithm is much better - faster and definetly less memory-eating.

depesz

--
hubert depesz lubaczewski                          http://www.depesz.pl/
------------------------------------------------------------------------
... vows are spoken to be broken ...                 [enjoy the silence]
... words are meaningless and forgettable ...             [depeche mode]

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Database corruption?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: INNER JOINS in 7.0.3 & 7.1.3